Informatics Practices
Select all records from emp table where deptno = 30 and sal > 1500.
SQL Queries
1 Like
Answer
SELECT * FROM emp
WHERE deptno = 30 AND Sal > 1500;
Answered By
1 Like
Related Questions
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 = 10 or 40.
Count number of managers (MGR column) and their salary in emp table.
How can we display all the employees grouped together on the basis of deptno and sal in descending order?