Query Needed

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

try this query

Quote:

---

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.

Quote:

---

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

---

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

regards,
Ram