Informatics Practices
Select all records from emp table where deptno = 10 or 40.
SQL Queries
1 Like
Answer
SELECT * FROM emp
WHERE deptno = 10 OR deptno = 40;
Answered By
2 Likes
Related Questions
Count the total salary deptno wise where more than 2 employees exist.
Suppose there is annual salary information provided by emp table. How can we fetch monthly salary of each and every employee?
Select all records from emp table where deptno = 30 and sal > 1500.
Count number of managers (MGR column) and their salary in emp table.