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.
- Practice
- SQL
- Basic Select
- Employee Salaries
- Discussions
Employee Salaries
Employee Salaries
dmeltz014 + 0 comments I think the question meant to say "Select a list of possible candidates for layoffs"
RodneyShag + 0 comments MySQL solution
From my HackerRank solutions.
SELECT name FROM Employee WHERE salary > 2000 AND months < 10 ORDER BY employee_id;
Let me know if you have any questions.
pol_alok + 0 comments My solution for MySql :)
SELECT name FROM employee WHERE (salary >2000 AND months<10) ORDER BY employee_id ASC;
h1906037 + 0 comments select name from Employee where salary>2000 and months<10 order by employee_id;
riyaagrahari + 0 comments SELECT NAME FROM EMPLOYEE WHERE SALARY>2000 AND MONTHS<10 ORDER BY EMPLOYEE_ID ASC;
Load more conversations
Sort 265 Discussions, By:
Please Login in order to post a comment