I want a SQL query that prints a list of employee names who have been employed for less than 10 months having salary>2000. Sort this result by ascending emp_id.

I tried this but gave me an error stating extract is no longer used.:

select * from emp where 
salary>2000 and (months_between(date, hire_date))<=10
order by emp_no asc ;

How do I form the query?

CodePudding user response：

SQL will automatically order by ascending, so you don't have to add that but you can if you want. The query should look something like this:

SELECT * 
FROM emp
WHERE salary >2000
AND hire_date >= DATEADD(Month, -10, getdate())
ORDER BY emp_no

CodePudding user response：

SELECT *
FROM Emp 
WHERE Salary > 2000
  AND DATEDIFF(month, Hire_Date, GetDate()) < 30
ORDER BY emp_no ASC;

db<>fiddle here