We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Basic Select
- Employee Salaries
- Discussions
Employee Salaries
Employee Salaries
Sort by
recency
|
1037 Discussions
|
Please Login in order to post a comment
For MySQL
SELECT name FROM Employee WHERE salary > 2000 AND months < 10 ORDER BY employee_id;
SELECT NAME FROM Employee WHERE SALARY > 2000 AND MONTHS < 10 ORDER BY EMPLOYEE_ID ASC;
SELECT NAME FROM EMPLOYEE WHERE MONTHS<10 AND SALARY>2000 ORDER BY EMPLOYEE_ID ASC;
select name from employee where employee.salary > 2000 and employee.months < 10 order by employee_id asc