SQL常用基础语句
1、select
语法:SELECT column1, column2, columnN FROM table_name
例句: SELECT * FROM COMPANY
解释:select为查询语句,从表格中选择字段(包括计算字段),返回结果表。
2、where
语法 :SELECT column1, column2, columnN FROM table_name WHERE [condition]
例句:SELECT * FROM COMPANY WHERE AGE IS NOT NULL
解释:筛选子句,返回结果时,考虑字段筛选条件(需配合操作符),针对每一行,需留意与Having区别
3、like
语法:SELECT column_list FROM table_name WHERE column LIKE ‘XXXX%’
例句:SELECT * FROM COMPANY WHERE ADDRESS LIKE ‘%-%’;
解释:匹配通配符指定模式的文本值,与where搭配使用,与通配符搭配使用
4、limit
语法:SELECT column1, column2, columnN FROM table_name LIMIT [no of rows]
例句:SELECT * FROM COMPANY LIMIT 6(offset rowid)
解释:返回结果限制行数量,可配合offset指定从哪开始检索。
5、distinct
语法:SELECT DISTINCT colu