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
  • Certification
  • Compete
  • Career Fair
  • Hiring developers?
  1. Practice
  2. SQL
  3. Basic Select
  4. Employee Salaries
  5. Discussions

Employee Salaries

Problem
Submissions
Leaderboard
Discussions

Sort 265 Discussions, By:

votes

Please Login in order to post a comment

  • dmeltz014 3 years ago+ 0 comments

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

    68|
    Permalink
  • RodneyShag 4 years ago+ 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.

    18|
    Permalink
  • pol_alok 1 year ago+ 0 comments

    My solution for MySql :)

    SELECT name
    FROM employee
    WHERE (salary >2000 AND months<10) ORDER BY employee_id ASC;
    
    5|
    Permalink
  • h1906037 1 week ago+ 0 comments

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

    0|
    Permalink
  • riyaagrahari 1 week ago+ 0 comments

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

    0|
    Permalink
Load more conversations

Need Help?


View top submissions
  • Contest Calendar
  • Blog
  • Scoring
  • Environment
  • FAQ
  • About Us
  • Support
  • Careers
  • Terms Of Service
  • Privacy Policy
  • Request a Feature