dmeltz014 I think the question meant to say "Select a list of possible candidates for layoffs"
pavan_vali was thinking the same :D
greenhand1 lol, agree
RodneyShag 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.
ranadipanshu938 question says salary should be greater than 2000 PER MONTH. your query check if it is greater than 2000 or not . explain please.
RodneyShag "salary is the their monthly salary" as it says in the problem.
Akshita_Sood Why does it give wrong answer if I use HAVING clause instead of WHERE clause?
RodneyShag paste your code here and we can take a look.
phani_g19 hope ur code is like "select name,salary,months from employee having salary >2000 and months < 10 order by employee_id;" sal,months are not expected in output.
2digantkaushik HAVING is used with GROUP BY and not ORDER BY. In the question you have been asked to sort according to the employee_id. This can be done by using ORDER BY.
BansheeGhoul Oracle :
SELECT name FROM Employee WHERE salary > 2000 and months< 10 ORDER BY employee_id asc;
15KD1A05B7CSEB [deleted]sbouzel Other with MS SQL Server, I don't think you can order by employee_id if employee_id is not in you select!
rahulmu4our This is my MySQL Query:-
SELECT name FROM Employee WHERE months < 10 AND salary > 2000;
shall we need to add command "ORDER BY employee_id" here. by default table itself, data is displayed in order of Employee ID. Not only that, it does't mention in question also.
knightofcode yes your query does pass the testcase
RodneyShag The question states to " Sort your result by ascending employee_id".
kartikrayaprolu1 We need to add "Order By employee_id" because it is specified that we need ascending order.
tayyabjsr13 What if months = 9 and salary = 9000
RodneyShag The line
salary > 2000 AND months < 10will match that (as in it will be true)
bumperlogos The question asks to order employee id ascending. ORDER BY employee_id ASC;
ASC = Ascending DESC = Descending
Pol_alok My solution for MySql :)
SELECT name FROM employee WHERE (salary >2000 AND months<10) ORDER BY employee_id ASC;
marinskiy Here is Oracle solution from my HackerrankPractice repository:
SELECT Name FROM Employee WHERE Salary > 2000 AND Months < 10 ORDER BY Employee_id;
Feel free to ask if you have any questions :)
eesrbr Oracle
Select name from Employee Where Salary >2000 and months < 10 order by employee_id ASC;
altafsofficial01 SELECT NAME FROM EMPLOYEE WHERE SALARY>2000 AND MONTHS<10;
MS SQL
SayakChakraborty select name from employee where salary > 2000 and months < 10 order by employee_id asc
dashingakd :'''''''''''''''(
SELECT name FROM Employee WHERE salary > 2000 AND months < 10 ORDER BY employee_id;
khairulazzrie MS SQL
SELECT name FROM Employee WHERE salary > 2000 AND months <10 ORDER BY employee_id ASC;
namvdo SELECT NAME FROM EMPLOYEE WHERE SALARY > 2000 AND MONTHS < 10 ORDER BY EMPLOYEE_ID
Sort 162 Discussions, By:
Please Login in order to post a comment