Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Consider the following SELECT statement: SELECT dept_no "Departments", MAX(salary) "Max Salaries" FROM empl...
- Employee table has salary field in this case if we give the query : select * from employee where sal<2000 a...
- Employee table has salary field in this case if we give the query : select * from employee where sal<2000 a...
- SELECT department, COUNT(1) FROM employees WHERE salary > 25000 GROUP BY department; What about this query ...
- Which clause in a query limits the rows selected?
- Select a query to display all the employees whose salary is between 1000 and 15000. Consider the following ...
- Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 W...
- Select a query to display the employee name whose salary is greater than the employee 7566. consider the fo...