SQL 简单查询之查询单条数据
TOP:
SELECT TOP 1 * FROM tb_userInfo;
SELECT TOP 1 * FROM tb_userInfo ORDER BY userId DESC;
LIMIT:
SELECT * FROM tb_userInfo LIMIT 1;
SELECT * FROM tb_userInfo ORDER BY userId DESC LIMIT 1;
♦ §这个世界的温柔来自于自身的强大!§ ♦
TOP:
SELECT TOP 1 * FROM tb_userInfo;
SELECT TOP 1 * FROM tb_userInfo ORDER BY userId DESC;
LIMIT:
SELECT * FROM tb_userInfo LIMIT 1;
SELECT * FROM tb_userInfo ORDER BY userId DESC LIMIT 1;