-
SQL语句
有时只需要取最后一条信息,避免信息过大。
-
TOP方法1
SELECT TOP 1 * FROM table_name SELECT TOP 1 * FROM user order by id desc; # 降序排列
-
LIMIT方法
SELECT * FROM table_name LIMIT 1; SELECT * FROM table_name ORDER BY col_name ASC LIMIT 1; # 升序,默认 SELECT * FROM table_name ORDER BY col_name DASC LIMIT 1; # 降序,最后一条
-
References


相关推荐