ANY answer.
Re: How to find second highest value of a column in a table?
[sql]SELECT * FROM product_master as e1
WHERE
(N =
(SELECT COUNT(DISTINCT (e2.prod_price))
FROM product_master as e2 WHERE e2prod_price >= e1.prod_price)
)[/sql]
where N is number you want
for example if you want 3rd highest than
[sql]SELECT * FROM product_master as e1
WHERE
(3 =
(SELECT COUNT(DISTINCT (e2.prod_price))
FROM product_master as e2 WHERE e2prod_price >= e1.prod_price)
)[/sql]
|