sql querry找到第二高的值 [英] sql querry to find 2nd highest value

问题描述

你好，

我有一个表名雇员..

 id name salary 
  1  a  10000  
  2  b  5000  
  3  c  8000  
 < span class =code-digit> 4  d  15000  
  5  e  18000  

我想要输出最高3笔交易，如下所示：

< pre lang =c＃> id name salary
5 e 18000
< span class =code-digit> 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	18000

I wanna a output of highest 3 transactions as below:

id  name  salary
5    e    18000
4    d    15000
1    a    10000

Please reply.

解决方案

Try:

SELECT TOP 3 * FROM employee ORDER BY salary

Select Top 3 *From employee order by salary DESC.

SELECT TOP 3 *
FROM  (SELECT *
       FROM   table_Name
       ORDER BY Salary)

这篇关于sql querry找到第二高的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！