你的位置:首页 > 数据库

[数据库]Part 5 Select statement in sql server


Select specific or all columnsselect * from 表名select * from Studentselect 列名,列名... from 表名select name,age,email from StudentDistinct rowsselect distinct 列名 from 表名select distinct name from StudentFiltering with where clause(子句)select * from Student where age>18Wild Cards in SQL ServerJoining multiple conditions using AND and OR operatorsselect * from Student where age>18 and name like 'gester%' or gender=1Sorting rows using order byselect name,email from Student order by nameSelecting top n or top n percentage of rowsselect top 10 * from Student