Query the max when there is a tie
829538Jan 7 2011 — edited Jan 8 2011Suppose i have a table with columns custName, custID, price, and description. From that table I need to display all the orders that paid the most (max price) with custName, description, and to_char(price)
Order
custName description to_char(price)
A desa $14
B desb $14
C desc $21
D desd $65
E dese $21
F desf $78
When I do select max(to_char(price)) from Order. it doesn't show both the max values. What I want is:
A desa $14
B desb $14
C desc $21
E dese $21