Category: MS SQL

A

Alias in SQL Server

Alias are used to provide alternate or temporary names to columns or tables, so their names can be more readable

L

LIKE in SQL Server

LIKE operator is used with WHERE clause to search for a specified pattern in a column with the use of

B

BETWEEN clause in SQL Server

BETWEEN operator select records within a given range with both the range included.It can be used for values of type

D

DISTINCT in SQL Server

DISTINCT clause is used in SQL Server to remove duplicates from the result set. It gives you the output without

O

ORDER BY in SQL Server

ORDER BY clause is used in SQL Server to arrange the records in either Ascending or Descending ORDER. SYNTAX :