4-sql Advanced Tutorials

1 TOP clause

The TOP clause is used to specify the number of records to return.

Syntax for SQL Server:

SELECT TOP number| ( PERCENT ) column_name (s) from table_name

MySQL syntax

SELECT column_name (s) from Table_namelimit number

Oracle syntax

SELECT column_name (s) from Table_namewhere ROWNUM <= number

2 Like operator

The LIKE operator is used to search for a specified pattern in a column in a WHERE clause .

3 SQL wildcard characters

Wildcard description% replaces one or more characters _ replaces only one character [charlist] Word columns any single character

[^charlist]

Or

[!charlist]

Any single character that is not in the word columns

4 in operator

The in operator allows us to specify multiple values in the WHERE clause .

5 between operator

operator between ... and selects a range of data between two values. These values can be numeric, text, or date .

SQL between syntax

SELECT column_name (s) from Table_namewhere column_name

（NOT）|

Between Value1 and value2

6 SQL alias syntax for SQL alias table

SELECT column_name (s) from Table_nameas Alias_name

SQL Alias syntax for columns

SELECT column_name as Alias_namefrom table_name

4-sql Advanced Tutorials