Mysql查询相关介绍

普通查询: select * from user where id>10;

查询最大值:select id,max(salary),min(value),count(*)  from userwhere  id>10;

分组查询:select department, max(salary) as col from user group by department having col>2000;having与where的区别是后者用于子查询的;

限定返回的记录数:select * from user limit 5;

mysql联合查询:

Mysql查询相关介绍,布布扣,bubuko.com

Mysql查询相关介绍

上一篇:代码修改mysql字符


下一篇:ORACLE 日期加减操作