找到第3个最高薪水 [英] Find the 3rd maximum salary
本文介绍了找到第3个最高薪水的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
亲爱的先生/女士......
我想获得第三个最高工资....
为此,以下给出的查询正在运作...
如果我们有多个相同的工资(45000)意味着它只显示最后一个插入值....我需要显示所有第3个最高工资
CREATE TABLE 员工([Eid] [ int ] NULL ,[Ename] [ nvarchar ]( 255 ) NULL ,[Basic_Sal] [ float ] NULL )
insert into 员工值( 1 ,< span class =code-string>' Neeraj', 45000 )
插入 进入员工 values ( 2 ,' Ankit', 5000 )
insert 进入员工值( 3 ,' Akshay', 6000 )
插入 进入员工值( 4 ,' Ramesh', 7600 )
插入 进入员工值( 5 ,' Vikas', 4000 )
插入 进入员工 values ( 7 ,' Neha', 8500 )
insert 到员工值( 8 ,' Shivika', 4500 )
插入 进入员工值( 9 ,' Tarun', 9500 )
插入 进入员工值( 10 ,' meera', 45000 )
插入 进入员工 values ( 11 ,' kajal', 45000 )
insert 进入员工值( 12 ,' hansika', 45000 )
选择 Ename,Basic_sal
来自(选择易名,巴斯ic_Sal,ROW_NUMBER() over ( order by Basic_Sal desc ) rowid 来自员工)A
其中 rowid = 3
先谢谢
解决方案
您好,
使用以下查询:
选择 Ename,Basic_sal,[rank]
来自(选择 Ename,Basic_Sal,DENSE_RANK() over ( order by Basic_Sal desc ) as [rank] 来自员工)A
其中 [rank] = 3
谢谢,
Bhagyesh
Dear Sir/Madam....
I want to get third maximum salary....
For that the given below query is working...
If we have more than one same salary(45000) means it will display last inserted value only.... I need to display all the 3rd maximum salary
CREATE TABLE Employee([Eid] [int] NULL,[Ename] [nvarchar](255) NULL,[Basic_Sal] [float] NULL)
insert into Employee values(1,'Neeraj',45000)
insert into Employee values(2,'Ankit',5000)
insert into Employee values(3,'Akshay',6000)
insert into Employee values(4,'Ramesh',7600)
insert into Employee values(5,'Vikas',4000)
insert into Employee values(7,'Neha',8500)
insert into Employee values(8,'Shivika',4500)
insert into Employee values(9,'Tarun',9500)
insert into Employee values(10,'meera',45000)
insert into Employee values(11,'kajal',45000)
insert into Employee values(12,'hansika',45000)
select Ename,Basic_sal
from(select Ename,Basic_Sal,ROW_NUMBER() over (order by Basic_Sal desc) as rowid from Employee)A
where rowid=3
Thanks in Advance
解决方案
Hi,
Use following query :
select Ename,Basic_sal, [rank] from(select Ename,Basic_Sal,DENSE_RANK() over (order by Basic_Sal desc) as [rank] from Employee)A where [rank]=3
Thanks,
Bhagyesh
这篇关于找到第3个最高薪水的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文