Top 5 salary amount

Question

Following are my sql table create table sales_employee ( name varchar(50) territory varchar(50) sales_amount int ) And Follwing are the records name territory sales_amount A X 100 B X 200 C X 200 D X 300 E X 400 F Y 300 G Y 300 H Y 500 I Y 600 J Z 200 K Z 700 So i need to find top 5 salary amount from above records but the condition is without using TOP keyword.. How i get that output without using TOP?

Rajeesh Menoth · Answer

Hi Try this code : SELECT * FROM ( SELECT ROW_NUMBER()OVER( ORDER BY sales_amount DESC ) AS rownumbersales_amount FROM sales_employee) AS foo WHERE rownumber

barathi raja · Answer

SELECT MAX(sales_amount) FROM (select distinct top 5 sales_amount from sales_employee order by sales_amount desc )as a this link to helpful for : http://www.c-sharpcorner.com/UploadFile/a20beb/find-the-3rd-or-nth-highest-salary-in-a-table-way-1/

Vinoth Balasubramanian · Answer

Try the below script for your problem If you are using SQL Server 2012+ SELECT * FROM sales_employee ORDER BY NAME ASC OFFSET 0 ROWS FETCH FIRST 5 ROWS ONLY Otherwise U can use this SELECT temp.* FROM ( SELECT * ROW_NUMBER() OVER (ORDER BY name) AS RowNumber FROM sales_employee ) temp WHERE RowNumber