SQL Server functions Use the

1.SQL TOP clause

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

Grammar:

Select Top Number/percent column_name (s) from table name

2.SQL Like operator

The LIKE operator is used for the specified pattern in the column in the WHERE clause.

Fuzzy query;

Grammar:

Select COLUMN_NAME (s) from table name where column_name like pattern

3.SQL wildcard characters

%: Replaces one or more characters.

_: Replaces one character.

[charlist]: Any single character in a character.

[^charlist] or [!charlist]: Any single character that is not in a character.

4.SQL in operator
Grammar:

Select COLUMN_NAME (s) from table name where column_name in (value1,value2 ...)

SQL Server functions Use the