SQL: LIKE, BETWEEN, IN Command Example

GTU DBMS Practical - 3
To perform queries using predicates LIKE, BETWEEN, IN .​
1) SQL LIKE Operator​
				
					SELECT *
FROM employee
WHERE emp_name LIKE '%j%';
Output
SQL: LIKE, BETWEEN, IN Command Example
2) SQL BETWEEN Operator
				
					SELECT *
FROM employee
WHERE emp_sal BETWEEN '2000' AND '10000';
Output
SQL: LIKE, BETWEEN, IN Command Example
3) SQL IN Operator
				
					SELECT *
FROM employee
WHERE dept_no IN (10, 15);
Output
SQL: LIKE, BETWEEN, IN Command Example
Output

SQL: LIKE, BETWEEN, IN Command Example


Latest Practical