本文介绍了sql querry找到第二高的值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
你好, 我有一个表名雇员..
id name salary 1 a 10000 2 b 5000 3 c 8000 4 d 15000 5 e 18000我想要输出最高3笔交易,如下所示: id name salary 5 e 18000 4 d 15000 1 a 10000
请回复。
解决方案尝试: SELECT TOP 3 * FROM employee ORDER BY 薪水
选择 顶部 3 *来自员工订单 按 salary DESC 。
SELECT TOP 3 * FROM ( SELECT * FROM table_Name ORDER BY 薪资)
Hello, I have a table name employee..
id name salary 1 a 10000 2 b 5000 3 c 8000 4 d 15000 5 e 18000I wanna a output of highest 3 transactions as below:
id name salary 5 e 18000 4 d 15000 1 a 10000Please reply.
解决方案 Try:SELECT TOP 3 * FROM employee ORDER BY salarySelect Top 3 *From employee order by salary DESC.SELECT TOP 3 * FROM (SELECT * FROM table_Name ORDER BY Salary)更多推荐
sql querry找到第二高的值
发布评论