Selecting the largest integer value from a column

[Wink-]

This is going to be an easy one for you smart people!

I am just looking to select the largest integer value from a column in a table.

SELECT `id` FROM `tbl_info` WHERE '[B]I'm not sure what to use here[/B]'

Thanks in advance.

[laserlight]

You can use the MAX() aggregate function, e.g.,

SELECT MAX(id) FROM tbl_info

[dealguru]

the MAX(id) works, but I'd like the row_id, so for example

• find largest id
• return row_id with largest id

something basically select row_id from 'table_info' where [id is the largest]

I tried:
SELECT fpuser_id FROM fpuser WHERE (v_age=(select MAX(v_age) from fpuser)

and that didn't work

[laserlight]

One possibility is:

SELECT fpuser_id FROM fpuser WHERE v_age IN (select MAX(v_age) from fpuser)

By the way, please start your own threads for your own questions next time.