Write an SQL query to find an employee whose salary is equal or greater than 10000?

Question

Can anyone tell the SQL query to find an employee whose salary is equal or greater than 10000?

Answer 1

You can use the following SQL query to find the employee details whose salary is equal or greater than 10000:

SELECT Emp_Name, E_id

FROM Employee

WHERE salary >= 10000

If you wish to learn SQL from top experts then check out this SQL Certification program by Intellipaat that provides instructor-led training, and also certification.

Answer 2

select emp_name,emp_id from employee where salary >1000;