Loading

Top 5 salary amount

Top 5 salary amount

RAHUL PATIL

10y1kSQL

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?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeesh Menoth10y ago
Hi,
Try this code :
SELECT*FROM(
SELECTROW_NUMBER()OVER(ORDERBYsales_amountDESC)ASrownumber,sales_amount
FROMsales_employee)
ASfoo
WHERErownumber<=5
0
barathi raja10y ago
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/
0
Vinoth Balasubramanian10y ago
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 <= 5
0