SQL之检索记录

1. select * from emp;
2. select * from emp where deptno=10;
3. select * from emp where deptno=10 and sal>1000;
4. select ename, deptno, sal from emp;
5. select ename as name, sal as salary, comm as commission from emp;
6. select * from (select ename, sal as salary from emp) x where salary>1200;
7. select concat(ename, ' works as a ', job) as message from emp;
8. 
   
9. select ename, sal,
10. case when sal<2000 then 'under paid'
11.   when sal>4000 then 'over paid'
12. else 'OK'
13. end as status
14. from emp;
15. 
    
16. select * from emp limit 5;
17. select ename, job from emp order by rand() limit 5;
18. select * from emp where comm is null; 
19. select * from emp where comm is not null;
20. select coalesce(comm,0) from emp;//if comm is null, replaced by 0;
21. select ename, job from emp where deptno in (10, 20);
22. select ename, job from emp where ename like '%er';
23. select ename, job from emp where job in ('salesman', 'clerk');