SQL Query

[thoand]

I have a colum storing numbers (1,2,3,45,78 etc) how can I get the row with the highest number?

regards Thomas

[bjwilke]

SELECT max(number_column) FROM table

[cahva]

Actually that last one only returns the number, not the whole row.
Use:
SELECT * FROM table ORDER BY number_column desc LIMIT 1