1.从table中读取某一Column(例如:dept_name)
代码:
select dept_name from departments;
结果:
2.从table中读取全部Column
代码:
select * from departments
结果:
3.从table中读取但去掉重复值
代码:
SELECT DISTINCT title FROM titles
结果:
4.从table中读取满足条件的数据
代码:
SELECT * FROM titles where title = 'staff'
结果:
5.AND运算符(找出first_name 是'Georgi'而且last_name是'Facello'的员工)
代码:
SELECT * FROM employees where first_name = 'Georgi' and last_name = 'Facello'
结果:
6.OR运算符(找出first_name 是'Georgi'或first_name 是'Parto'的员工)
代码:
SELECT * FROM employees where first_name = 'Georgi' or first_name = 'Parto'
结果:
7.结合 AND & OR(找出男性员工中,last_name 是'Koblick'或是'Facello'的员工)
代码:
SELECT * FROM employees where gender = 'M' and ( last_name = 'Koblick' or last_name = 'Facello' )
结果:
8.ORDER BY实例(找出所有员工,并依据birth_date排序)
代码:
SELECT * FROM employees ORDER BY birth_date
结果:
9.ORDER BY DESC实例(找出所有员工,并依据birth_date降序排序)
代码:
SELECT * FROM employees ORDER BY birth_date DESC
结果:
10.ORDER BY 多列实例(找出所有员工,并birth_date与first_name降序排序)
代码:
SELECT * FROM employees ORDER BY birth_date, first_name
结果: