1
--范围查询
SELECT * FROM authors WHERE zip between '94025' AND '94618'
2--模糊查询
SELECT * FROM authors WHERE au_fname LIKE '[a-j]%'
3 --DISTINCT 查询不重复的记录
SELECT DISTINCT([字段名]) FROM [Table]
4- -- IN 查询
SELECT * FROM [Table] WHERE au_fname IN('A','B')
5 --查询当天记录：
--范围查询SELECT * FROM authors WHERE zip between '94025' AND '94618'2
--模糊查询SELECT * FROM authors WHERE au_fname LIKE '[a-j]%'3 --DISTINCT 查询不重复的记录
SELECT DISTINCT([字段名]) FROM [Table]
4- -- IN 查询
SELECT * FROM [Table] WHERE au_fname IN('A','B')
5 --查询当天记录：
SELECT * FROM [TABLE] WHERE DETEDIFF('d', registdate, Date()) ==0
