Select : Select Query : SQL Server / T-SQL examples (example source code) Organized by topic

Java Java Tutorial Java Articles Java Products Java by API C# / C Sharp ASP.Net JavaScript DHTML JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C++ PHP Python SQL Server / T-SQL Oracle PL/SQL PostgreSQL SQL / MySQL VB.Net

SQL Server / T-SQL Home »  Select Query   » [  Select  ]

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'