数据库之MQL

 1,查询所有

mysql> select * from grade;

2,

mysql> select id,firstname,lastname from grade;

3,

mysql> select firstname,lastname from grade where id > 4;

4,

mysql> select * from grade where sex = 'f';


5,

mysql> select * from grade where id=2 or id =4 or id=6;

6,

mysql> select * from grade where math between 85 and 94;

7,

mysql> select * from grade where firstname like 'A%';

8,

mysql> select * from grade where firstname like 'A%e';

9,

mysql> select * from grade where firstname like '%l%';

10,

mysql> select * from grade where firstname like 'A____';

11,

mysql> select * from grade where english between 85 and 94;

12,

mysql> select * from grade where math >90 or chinese >90 ;

13,

mysql> select * from grade where id !=1 and  id!=3 and id!= 5 and id!=7;

14,

mysql> select distinct sex from grade;

15,

mysql> select distinct lastname from grade;

16,

mysql> select count(id) from grade ;

17,

mysql> select count(id) from grade where english > 80 ;

18,

mysql> select sum(math) from grade;

19,

mysql> select sum(math) from grade where sex ='f';

20,

mysql> select avg(english) from grade;

21,

mysql> select avg(english) from grade where sex = 'm';

22,

mysql> select max(math) from grade;

23,

mysql> select max(math) from grade where sex='m';

24,

mysql> select * from grade order by math asc;

 

25,

mysql> select * from grade order by sex  asc,chinese desc;

26,


mysql> select sex,GROUP_CONCAT(CONCAT(firstname, ' ', lastname) SEPARATOR ', ') AS students_list from grade group by sex;

 

27,

mysql> select count(*) from grade group by lastname;

28,

29,

mysql> select * from grade where id between 3 and 6;

30,

select id,sex,firstname,lastname,(english + math + chinese) / 3 AS average from grade where sex = 'm' AND (english + math + chinese) / 3 > 85;

相关推荐

  1. 网络知识点-MPLS VPN

    2024-07-10 12:16:03       46 阅读
  2. MongoDB数据更新中的乘法$mul

    2024-07-10 12:16:03       23 阅读

最近更新

  1. docker php8.1+nginx base 镜像 dockerfile 配置

    2024-07-10 12:16:03       4 阅读
  2. Could not load dynamic library ‘cudart64_100.dll‘

    2024-07-10 12:16:03       5 阅读
  3. 在Django里面运行非项目文件

    2024-07-10 12:16:03       4 阅读
  4. Python语言-面向对象

    2024-07-10 12:16:03       5 阅读

热门阅读

  1. 【maya插件开发】vscode debug python 代码

    2024-07-10 12:16:03       9 阅读
  2. 【AI应用探讨】—主成分分析(PCA)应用场景

    2024-07-10 12:16:03       11 阅读
  3. 基数排序算法Python实现

    2024-07-10 12:16:03       9 阅读
  4. qt todoapp

    2024-07-10 12:16:03       8 阅读
  5. 如何减少开发过程中的bug-数据库篇

    2024-07-10 12:16:03       9 阅读
  6. 驻场运维的前途在哪里,这里有金玉良言

    2024-07-10 12:16:03       9 阅读
  7. 认字之 刬

    2024-07-10 12:16:03       7 阅读
  8. lvs集群

    lvs集群

    2024-07-10 12:16:03      9 阅读
  9. AUTOSAR:汽车软件架构的未来

    2024-07-10 12:16:03       9 阅读
  10. 相机光学(二十九)——显色指数(Ra)

    2024-07-10 12:16:03       9 阅读
  11. 贪心算法合集一

    2024-07-10 12:16:03       8 阅读