use Scott 使用 Scott这个数据库
show tables;查看表
select * from emp; 查询emp(员工信息表)这个表
select * from dept; 查询dept(部门信息表)这个表
select * from salgrade; 查询salgrade(工资级别表)这个表
select enamel,sal from emp;查询emp这个表的enamel和sal这两列
select enamel,(sal+200)*3 newsal from emp;
select enamel, sal,comm,sal+ifnull(comm ,0) zongshouru from emp;
select distinct deptno from emp;删除deptno这列的重复行
select * from emp where deptno=30
select * from emp where sal>3000;条件查询
select * from emp where ename like `%TT%`;
select * from emp where ename like `_LL%`;
select * from emp where ename like `__LL%`;like模糊查询
select * from emp where deptno=30 and sal>2000;
select * from emp where deptno=30 or sal>2000;
select * from emp where not sal>2000;
select * from emp order by sal;按照sal排序,默认是升序
select * from emp order by sal desc;按照sal降序
select * from emp order by deptno,sal;按两列排列
select * from emp order by deptmo desc,sal desc;
select concat(ename,'\'s sal is',sal)from emp;连接
select count(*) from emp;count计数
select sum(sal),min(sal),max(sal),avg(sal) from emp;求和 最小 最大 平均
select deptno,sum(sal),min(sal),max(sal),avg(sal) from emp group by deptno;分组查询
select ename,dname from emp , dept where emp.deptno=dept.deptno;多表查询
select y.ename , j.ename from emp y , emp j where y.mgr=j.enpno; 自连接
select ename,sal,grade from emp,salgrade where sal between losal and hisal; between...and..查询
select ename,dname,sal,grade from emp,dept,salgrade where emp.deptno=dept.deptno and emp.sal between losal and hisal; 三张表的连接查询 where and
mariadb的查询语句
最新推荐文章于 2024-05-30 20:03:03 发布