且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何选择前3名工资

更新时间: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 this

SELECT TOP 3 SALARY
FROM   EMPLOYEE
ORDER BY SALARY DESC


check this...
How to get top 5 salary data in sql query[^]