RAHUL PATIL

RAHUL PATIL

  • NA
  • 145
  • 11.4k

Top 5 salary amount

Jun 17 2016 6:34 AM
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?
 

Answers (3)