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
|
1083 Discussions
|
Please Login in order to post a comment
My solution:
SELECT name from employee where salary > 2000 AND months < 10 ORDER BY employee_id;
MYSQL : Select name from employee where salary > 2000 and months < 10 order by employee_id;
MySQL solution:
select name from EMPLOYEE WHERE SALARY > 2000 AND MONTHS < 10;