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;

Answer 3

Whether it is for obtaining or preparing an output of employees that are earning in excess of ten thousand, a select query with where clause would satisfy. The Where clause is going to will select only those rows where the salary is going to be more than ten thousand.

Here is the code to implement that:

SELECT *

FROM employees

WHERE salary >= 10000;