1) How to display nth highest record in a table for example? How to display 4th highest (salary) record from customer table?
SELECT DISTINCT(`salary`) FROM `customer` ORDER BY `salary` DESC LIMIT 3,1;
1) How to display nth highest record in a table for example? How to display 4th highest (salary) record from customer table?
SELECT DISTINCT(`salary`) FROM `customer` ORDER BY `salary` DESC LIMIT 3,1;