SQL高级查询等语法

--TOP语法
SELECT TOP number|percent column_name(s)
FROM table_name
--like语法
SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern
--SQL语句IN语法
SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...)
--between语法
SELECT column_name(s)
FROM table_name
WHERE column_name
BETWEEN value1 AND value2
--inner join语法
SELECT column_name(s)
FROM table_name1
INNER JOIN table_name2 
ON table_name1.column_name=table_name2.column_name
--left join语法
SELECT column_name(s)
FROM table_name1
LEFT JOIN table_name2 
ON table_name1.column_name=table_name2.column_name
--right join语法
SELECT column_name(s)
FROM table_name1
RIGHT JOIN table_name2 
ON table_name1.column_name=table_name2.column_name