Codechef4u is a community for computer professionals,by computer professionals,just like you; who loves sharing and helping each others,Join them
Share your post

SQL IN operator

SQL IN

IN operator allows you to specify multiple values in where clause and retrieve data matching a list of values.

Syntax:

SELECT column_1,column_2..column n
FROM table_name
WHERE some_column IN (value1,value2,...);

Example :

SELECT  * FROM Categories WHERE CategoryID in(1,2,3) 

Example with sub-query :

SELECT  * FROM Products WHERE CategoryID in(SELECT CategoryID FROM Categories WHERE CategoryName='books')

Result set:


SQL Between operator

SQL Between

The BETWEEN operator is used to select values within a range in a SELECT, INSERT, UPDATE, or DELETE statement.

Note:

 1. BETWEEN operators return records where expression is within the range of value1 and value2 (inclusive).
 2. The between values can be numbers, text, or dates.

Syntax:

SELECT column_1, column_2..column_n FROM tableName
WHERE some_column BETWEEN value1 AND value2;


Example:

SELECT  * FROM Categories WHERE CategoryID BETWEEN 1 and 5

SQL Select Top

The SELECT TOP clause is used to specify the number of records to return from result set.

Top clause is useful if table contains large amount of data.

Note: All RDBMS Datbases doesn't support top (example ORACLE,MySql doesn't support top but MS-SQL supports TOP)

Syntax:

SELECT TOP number|percent  column 1, column 2..column n FROM tableName;

 

Example:

 SELECT TOP 2 CategoryName,[Description] FROM Categories

Result: