sql 查询最大非主键ID方法

 方法1：

select top 1 * from table order by id desc

方法2：

 

select MAX(id) from tb_user ORDER BY id desc

方法3：

select title from message where id=(select max(id)from message)


select title from message order by id desc