Question

sql语句中要查询ID字段内容最大的记录怎么查询

Sq1="select MAX(ID) from job_01 ORDER BY id desc"这样写好像不对

Answer 1

SELECT id from job_01 order by id desc limit 1 (mysql)SELECT top 1 id from job_01 order by id desc (sql server)

Answer 2

select max(id) as sid from job_01

Answer 3

select * from job_01where id=(select max(id) from job_01) 你看下你是要这样的结果不？不是的在问，说清楚点！