fourth highest salary in a table [Resolved]

Posted by Krishnamanohar under Sql Server on 4/22/2013 | Points: 10 | Views : 1836 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi experts,
what is best way of getting the fourth highest salary of an employee if two employees having same fourth highest salary?not using dense rank and top?
Thanks in Advance
Krish

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Kirthiga on: 4/24/2013 [Member] Starter | Points: 50

0	Hi Krishnamanohar, I think Dense_Rank is the best and simple way for getting the highest salary Krishnamanohar, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jayakumars on: 4/23/2013 [Member] [MVP] Bronze | Points: 25

0	hi try this Query Select ,Row_Number() over (order by Salary Desc)as Id from Tbl_Salary where Id=4 Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Krishnamanohar, if this helps please login to Mark As Answer*. \| Alert Moderator

Latest Posts