Select « Select Query « SQL Server / T-SQL

1.Use regular expressions to retrieve table data
2.Sorting Results
3.Using Functions in Queries
4.Using TOP in select statement
5.Select a single row
6.Group by, having and order
7.Use your function in select statement
8.Using the CASE Statement
9.Queries Involving Null Values

10.Get full details of all departments using *
11.SELECT: return literal values that are just part of an expression
12.An expression-type result set can be aliased and treated as if it were a table
13.Select with 'Case when'