Easy way to get min record?

[Charisma Bypass]

Is there an -easy- way to get the minimum value from a databse query (without running a previous sql to grab the lowest number);

SELECT * from table WHERE id ={lowest existing id}


Thanks in advance

[Tony]

can't you select * from table order by id asc then just pull out the first record?

[neal]

SELECT * FROM [tableName] ORDER BY [id] ASC LIMIT 1

[keri]

SELECT * FROM [tableName] ORDER BY [id] ASC LIMIT 1

and if it is MS SQL it would end up as SELECT TOP 1 * FROM TABLENAME ORDER BY ID

[JasonD]

Two queries would be faster, SELECT MIN(id).... and .... WHERE id=?, in theory at least. You'd probably need a lot of data to notice.

[Jeep Stone]

If you only wanted the id, don't use *. In fact, don't use * at all, only return the fields you want.

SELECT * FROM [tableName] ORDER BY [id] ASC LIMIT 1

and if it is MS SQL it would end up as SELECT TOP 1 * FROM TABLENAME ORDER BY ID

[neal]

If you only wanted the id, don't use *. In fact, don't use * at all, only return the fields you want.

SELECT * FROM [tableName] ORDER BY [id] ASC LIMIT 1

and if it is MS SQL it would end up as SELECT TOP 1 * FROM TABLENAME ORDER BY ID

yeah, i would have said that too but was in a rush to get to a presentation this morning. only return the fields you need. it means more typing on your part but it also means a faster query, less data being passed between mysql & php (or mssql & asp), less to go wrong if you change the table structure & more secure scripts.

[Charisma Bypass]

Thank You guys, I do appreciate it!  Cheers