How we got top ten employee salary

[anis2007]

Good morning to all of you,
Plz tell , how i write the query that i got top ten employee salary.

Thankyou



Regards
anu2007

[sashi]

Hi there,

Kindly refer to below SQL statement, hope it helps. Good lukc & take care.

  SELECT TOP 10 fld1, fld2, fld3 FROM tblName

[ronverdonk]

Or use

SELECT salary FROM table_name ORDER BY salary DESC LIMIT 10

Ronald :cool: