SELECT

Using the wildcard character to select all columns in a query.

SELECT Using Column Aliases

Select Individual Columns

Selecting specified number of records

Selecting with Condition

Selecting with CASE

Select columns which are named after reserved keywords

Selecting with table alias

Selecting with more than 1 condition.

Selecting with Aggregate functions

Get aggregated result for row groups

Selection with sorted Results

Selecting without Locking the table

Select with condition of multiple values from column

Select distinct unique values only

Selecting with null

Select rows from multiple tables