SQL IN Operator
SQL IN operator allows you to select records for specified multiple values.
IN Operator is used with WHERE clause and It is separated by commas.
SELECT * from Table_Name Where Column_Name IN (value1,value2,…)
The following table “Employee” is created in a database.
The Following query select all records whose “DepartmentId” are 101 and 102.
SELECT * FROM Employee where DepartmentID IN (101,102)
SQL BETWEEN Operator
SQL Between operator allows you to select records for given range of values.
SELECT * from Table_Name Where Column_Name BETWEEN value1 AND value2
The Following query select all Employee records whose salary between “10000” and “20000”
SELECT * FROM Employee where salary between 10000 and 20000
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.