sql query

krsjacob

New Member

Join Date: Mar 2008

Posts: 1
#1

sql query

Mar 27 '08, 10:24 AM

I need the query for finding the maximum three salary persons in employee
table...
Tags: None
deepuv04

Recognized Expert New Member

Join Date: Nov 2007

Posts: 227
#2

Mar 27 '08, 12:03 PM

Originally posted by krsjacob

I need the query for finding the maximum three salary persons in employee
table...

hi,

try it...
[code=sql]

SELECT TOP 3 * FROM Table_Name ORDER BY Salary DESC
[/code]
thanks
Comment

Comment