Query all employe names from Employee table having salary greater than $2000

Query all employe names from Employee table having salary greater than $2000

Instructor-svg Al-Mamun Sarkar
Mar 28 , 2020

Query all employe names from Employee table having salary greater than $2000 and months less than 10 months and sort by employee_id in ascending order. This is the solution of HackerRank's Employee Salaries SQL problem.

Table name: Employee

SQL Query:

SELECT name FROM employee
WHERE salary > 2000
AND months < 10
ORDER BY employee_id ASC

 

  • Share On:
  • fb
  • twitter
  • pinterest
  • instagram