Query Needed

[intelram_18]

Hi all,
I want to find the 5th max value , kindly send me the simple query .

[barbara1712]

try this query

select fieldname from tablename order by fieldname desc
limit 4,1

where fieldname is name of the field for which you want the 5th maximum value
eg.

select salary from employee order by salary desc limit 4,1

[intelram_18]

Hi,
Thank U for send query . Its working corretly.

regards,
Ram