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.
Loading...
  1. Practice
  2. SQL
  3. Basic Select
  4. Employee Salaries
  5. Discussions

Employee Salaries

Sort 133 Discussions, By:

votes

  • dmeltz014 + 2 comments

    I think the question meant to say "Select a list of possible candidates for layoffs"

    • pavan_vali + 0 comments

      was thinking the same :D

    • greenhand1 + 0 comments

      lol, agree

  • RodneyShag + 8 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.

    • ranadipanshu938 + 1 comment

      question says salary should be greater than 2000 PER MONTH. your query check if it is greater than 2000 or not . explain please.

      • RodneyShag + 0 comments

        "salary is the their monthly salary" as it says in the problem.

        HackerRank solutions.

    • Akshita_Sood + 3 comments

      Why does it give wrong answer if I use HAVING clause instead of WHERE clause?

      • RodneyShag + 0 comments

        paste your code here and we can take a look.

      • phani_g19 + 0 comments

        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 + 0 comments

        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 + 0 comments

      Oracle :

      SELECT name FROM Employee WHERE salary > 2000 and months< 10 ORDER BY employee_id asc;

    • 15KD1A05B7CSEB + 0 comments
      [deleted]
    • sbouzel + 0 comments

      Other with MS SQL Server, I don't think you can order by employee_id if employee_id is not in you select!

    • rahulmu4our + 3 comments

      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 + 0 comments

        yes your query does pass the testcase

      • RodneyShag + 0 comments

        The question states to " Sort your result by ascending employee_id".

        HackerRank solutions.

      • kartikrayaprolu1 + 0 comments

        We need to add "Order By employee_id" because it is specified that we need ascending order.

    • tayyabjsr13 + 1 comment

      What if months = 9 and salary = 9000

      • RodneyShag + 0 comments

        The line salary > 2000 AND months < 10 will match that (as in it will be true)

        HackerRank solutions.

    • bumperlogos + 0 comments

      The question asks to order employee id ascending. ORDER BY employee_id ASC;

      ASC = Ascending DESC = Descending

  • marinskiy + 0 comments

    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 :)

  • raginiraj186 + 0 comments

    select name from employee where salary >2000 and [months] <10 order by employee_id asc;

    note: month is a keyword so donot forgot to keep it in bracket.

  • priyasuthar141 + 0 comments

    for oracle : select name from employee where salary>2000 AND months<10;

  • kavin_Vignesh + 0 comments

    select name from employee where salary>2000 and months<10 order by employee_id asc;

  • abhishek_adivar1 + 0 comments
    SELECT name
FROM Employee
WHERE salary>2000 AND months<10
ORDER BY employee_id

  • naik2191 + 0 comments

    MySQL : 

    SELECT NAME
FROM EMPLOYEE
WHERE 
    SALARY > 2000
    AND
    MONTHS < 10
ORDER BY EMPLOYEE_ID;

  • rjshekar90 + 0 comments
    SELECT NAME 
FROM EMPLOYEE
WHERE SALARY > 2000 AND MONTHS < 10
ORDER BY EMPLOYEE_ID

  • _Sheetal + 0 comments
    SELECT NAME FROM EMPLOYEE WHERE SALARY >2000 AND MONTHS<10 ORDER BY EMPLOYEE_ID ASC;
Load more conversations