查找数据

﹏ヽ暗。殇╰゛Y 2022-05-19 02:41 171阅读 0赞

![70][]

![70 1][]

只查找指定的字段：

select id ,usersname from users;

![70 2][]

select users.id,users.username from users;针对多表查询

换名查找

select id as userid,username as uname from user;

![70 3][]

select id as usersname from users;

![70 4][]

条件查找

![70 5][]

![70 6][]

![70 7][]

select sex from users group by sex ;

select sex from users group by 1 ;

对sex栏所有数据结果进行分组；

也可以对对指定的记录进行分组：

![70 8][]

select sex，age  from users group by 1 having age>35,在所有记录中，在age大于当前条件下，进行分组

主义age也要在select语句里；

select sex from users group by 1 having count(id) >=2;意思是  sex的值为2的有几个？

此处的id出现在聚合函数内

![70 9][]

![70 10][]

select \* from users order by id desc,通过降序排列

select \* from users order by age ,age默认升序从小到大排列，

select \* from users order by age ，id desc;

![70 11][]

![70 12][]

limit3,2的意思是从下标为3（下标从0开始）的记录开始返回，返回2条数据；

![70 13][]

虽然是降序排列，但是limit里的第一个数和id没有关系，只与数据集里的排列顺序有关

[70]: /images/20220519/3db14db8db5b431ab8f6fa46534d7273.png
[70 1]: /images/20220519/d880555dae9f4b5480950fdc05ba57fb.png
[70 2]: /images/20220519/fd08d90c1508405ab92f0fb525d9f4dd.png
[70 3]: /images/20220519/b0442ede8be64ca1ad9832d17e054377.png
[70 4]: /images/20220519/e9afdf7a724b41a7affe94d11cf442d4.png
[70 5]: /images/20220519/fade72640afb4731b8c47293c92e8dc6.png
[70 6]: /images/20220519/594ba67a49ec4170ba09ec5353b2d76e.png
[70 7]: /images/20220519/6172c46abd8642aeac9fb1b4bfac3568.png
[70 8]: /images/20220519/773d186213eb4bbd95682cab28d7bffd.png
[70 9]: /images/20220519/668113d3cfbd4164bb6c74e559d2812b.png
[70 10]: /images/20220519/45a06ed7b56e49e5804643dc245f6b67.png
[70 11]: /images/20220519/98ab3a59b5704d91b3b32302a5b973f5.png
[70 12]: /images/20220519/dabb2aa69ccb44b694e867458f668e53.png
[70 13]: /images/20220519/ffb66d5bcbcc49d2a8c22811ebcb2065.png