--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
SQL高级查询等语法
最新推荐文章于 2022-07-26 17:02:05 发布