biggest value 1

[curvv]

Hi,

If I got values 1,2,3,4,5,6 in a column, how do i get the biggest number?

i.o.w: SELECT * FROM tbl_table WHERE id is the biggest

thanx

######## CtN ########

 

[Broccoli2]

Try

SELECT MAX(id) FROM tbl_table;

or alternatively, if you need all the columns,

SELECT * FROM tbl_table ORDER BY id DESC LIMIT 1;

Hope this helps
-Rob