更新时间:2023-02-26 10:11:46
假设您正在使用MS SQL,那么它是非常基本的SQL。试试这个
SELECT TOP 3 SALARY
FROM EMPLOYEE
ORDER BY SALARY DESC
检查这个...
如何在sql查询中获得前5名薪资数据 [ ^ ]
I have a table employee having salary column.
ID Salary
== ======
1 10000
2 10000
3 30000
4 20000
5 25000
now how to select top 3 salaries in a single query.
Well its quite basic SQL assuming you are using MS SQL. Try thisSELECT TOP 3 SALARY FROM EMPLOYEE ORDER BY SALARY DESC
check this...
How to get top 5 salary data in sql query[^]