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;

posted @ 2019-03-06 11:37  云梦&&玄龙  阅读(1415)  评论(0)    收藏  举报