當前位置:編程學習大全網 - 網站源碼 - sql查詢語句 給出4張表,找出雇員最多的公司

sql查詢語句 給出4張表,找出雇員最多的公司

mysql

select company_name, count(employee_name) employee_count

from works

group by company_name

order by count(employee_name) desc limit 1,1

sql server

select top 1 company_name, count(employee_name) employee_count

from works

group by company_name

order by count(employee_name) desc

  • 上一篇:求壹個特勤隊私服遊戲源碼!
  • 下一篇:什麽剃須刀好用?質量好的。
  • copyright 2024編程學習大全網