CBSE Class 12 Informatics Practices Question 17 of 79

Database Query using SQL — Question 9

Back to all questions
9
Question

Question 9

Select all records from emp table where deptno = 30 and sal > 1500.

Answer
SELECT * FROM emp 
WHERE deptno = 30 AND Sal > 1500;