3 replies to this topic

[Tank314]

How do I type query with maximum value in specific column?
I can select max price but not whole row with max price.

[WingedPanther]

You will have to specify each field you want to return, and use the group by clause for those fields as well.

[Tank314]

SELECT *
FROM cars
WHERE price=max

?

[WingedPanther]

Ah:

select * from cars where price = (select max(price) from cars)