SELECT NAME,sex FROM emp;
SELECT * FROM emp;
SELECT NAME,salary * 12 + bonus FROM emp;
SELECT NAME,sex 性别 FROM emp;
SELECT * FROM emp WHERE sex ='女';
SELECT * FROM emp WHERE salary BETWEEN 8000 AND 12000;
SELECT * FROM emp WHERE NAME IN ("张三","李四","张飞");
SELECT * FROM emp WHERE NAME LIKE '%云%';
SELECT * FROM emp WHERE bonus IS NOT NULL;
SELECT * FROM emp WHERE sex='女' AND hiredate> DATE'2010-1-1';
SELECT * FROM emp ORDER BY salary DESC;
SELECT * FROM emp ORDER BY salary DESC,bonus DESC;
SELECT NAME FROM emp ORDER BY CONVERT(NAME USING GBK);-- name是utf-8格式 USING GBK 编码支持拼音排序。
SELECT NAME FROM emp ORDER BY salary DESC LIMIT 0,3;
SELECT NAME,
CASE WHEN salary < 10000 THEN '低收入'
WHEN salary < 20000 THEN '中等收入'
ELSE '高收入'
END AS "薪水等级"
FROM emp;
SELECT COUNT(*),AVG(salary),MAX(salary),MIN(salary),SUM(salary) FROM emp;
SELECT d.name,COUNT(*),AVG(salary) FROM emp e,dept d WHERE e.did=d.id GROUP BY d.name;
SELECT d.name,AVG(salary) FROM emp e,dept d WHERE e.did=d.id GROUP BY d.name HAVING AVG(salary)>10000;
SELECT d.name,COUNT(*) FROM emp e,dept d WHERE e.did=d.id GROUP BY d.name HAVING COUNT(e.did)>5
SELECT e.name,d.name FROM emp e,dept d WHERE e.did=d.id
SELECT d.name,COUNT(e.name) FROM emp e,dept d WHERE e.did=d.id GROUP BY d.name
SELECT e.name 员工名字,m.name 领导名字 FROM emp e,job m WHERE e.mid=m.id;
SSELECT d.name FROM emp e,dept d WHERE e.did=d.id AND d.name IN(SELECT * FROM emp WHERE sex ='女');
####sql题
最新推荐文章于 2024-07-20 17:22:43 发布