Scaz is a place dedicated to providing the content, skills, tools and services you need to learn and succeed in making money online.
Where Clause in SQL
The WHERE clause is used to add a condition to filter the records when we want to fetch the specific records instead of all records. Syntax: To specify a condition we can use any logical operator like >, <, =, LIKE, NOT etc. Example: Output:
Alias in SQL
The ALIAS statement is used to temporarily rename a table or column in a SQL statement. Syntax: Example: Output:
Not Between Operator in SQL
The BETWEEN operator is used to select values within a range. The values can be numbers, dates or text. Syntax: The value of the conditioned column should not be in the given range specified by NOT BETWEEN operator. Example: Output:
Between Operator in SQL
The BETWEEN operator is used to select values within a range. The values can be numbers, dates or text. Syntax: The value of the conditioned column should be in the given range specified by BETWEEN operator. Example: Output:
Not In Operator in SQL
The NOT IN operator is used to reduce the multiple or conditions by specifying the multiple values in a where clause. Syntax: The value of the conditioned column should not be equal to the any of the specified values in the NOT IN operator. Example: Output:
SQL Select in Operator
The IN operator is used to reduce the multiple or conditions by specifying the multiple values in a where clause. Syntax: The value of the conditioned column should be equal to the any one of the specified values in the IN operator. Example: Output:
Select Top in SQL
The SELECT TOP statement is used to retrieve the top specified number of rows from a table. Syntax: Where n is the number of rows. Example: Output:
Distinct Keyword in SQL
The DISTINCT keyword is used to retrieve the unique records by eliminating the all duplicate records. Syntax: Example: Output: