常用简单sql语句.docxVIP

常用简单sql语句

常用SQL语句大全

基础查询语句

```sql

--查询所有列

SELECT*FROMemployees;

--查询特定列

SELECTfirst_name,last_name,emailFROMemployees;

--去重查询

SELECTDISTINCTdepartment_idFROMemployees;

--条件查询

SELECT*FROMemployeesWHEREsalary5000;

--多条件查询

SELECT*FROMemployeesWHEREdepartment_id=5ANDsalary6000;

--范围查询

SELECT*FROMemployeesWHEREsalaryBETWEEN4000AND8000;

--集合查询

SELECT*FROMemployeesWHEREdepartment_idIN(1,3,5);

--模糊查询

SELECT*FROMemployeesWHEREfirst_nameLIKEJ%;

SELECT*FROM