Select specific or all columns

select * from 表名

select * from Student

select 列名，列名... from 表名

select name,age,email from Student

Distinct rows

select distinct 列名 from 表名

select distinct name from Student

Filtering with where clause(子句)

select * from Student where age>18

Wild Cards in SQL Server

Joining multiple conditions using AND and OR operators

select * from Student where age>18 and name like 'gester%' or gender=1

Sorting rows using order by

select name,email from Student

order by name

Selecting top n or top n percentage of rows

select top 10 * from Student