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

SQL stands for Structured Query Language. It is used to fetch the data from Relational databases or tables with the help of some queries. 

In SQL, to find an employee whose salary is equal to or greater than 10000. We have to use the WHERE clause. In this blog, we will learn how to perform this task in detail.

Table of Contents:

• SQL query to find an employee whose salary is equal to or greater than 10000.
• Filters to the Employee table
  • Example 1: Filter the row having dep=’IT’ and salary is greater than 5000.
  • Example 2: Find the Employee having salary is greater than 100000 and give the output in a sorted way.
  • Example 3: Find the Employee whose department is either of them (‘HR’ and ‘Sales’)
• Conclusion
• FAQs

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

To find the employee whose salary is equal to or greater than 10000 in SQL, we have to use the SELECT statement and WHERE clause.

Example: suppose we have a table of Employees,  and we have to find the employees having salaries greater than 10000.

Query:

SELECT * FROM employees  
WHERE salary >= 10000;

Output:

Explanation: Here we have used the SELECT statement to select the rows from the employee table, and the WHERE clause is used to filter the rows based on the condition (salary >= 10000).

Filters to the Employee table

We can also add some more features to the table according to our needs:

Example 1: Filter the row having dep=’IT’ and salary is greater than 5000.

Here, we want to print the rows having department IT and salary greater than 5000. let’s have a look at below Query:

Query:

SELECT * FROM employees  
WHERE salary >= 5000 AND department = 'IT';

Output:

Example 2: Find the Employee having a salary greater than 10000 and give the output in a sorted way.

Here, we have to print the rows in a sorted way having a salary greater than 10000.

Query:

SELECT * FROM employees  
WHERE salary >= 10000
ORDER BY salary DESC;

Output:

Explanation: We have used the ORDER BY command here, which is used to sort the data, we have sorted the data according to salary by the command, ORDER BY salary DESC.

Example 3: Find the Employee whose department is either of them (‘HR’ and ‘Sales’)

Query:

SELECT * FROM employees
WHERE department IN ('HR', 'Sales');

Output:

Explanation: Here we have used the SQL IN operator to find whether the employee belongs to the HR or the sales department.

Conclusion

SQL is used to retrieve data from tables and displaying into our codes. Here in this article, we have learned how we can find an employee with a salary greater than 10000, and we have also applied some more filters to that output. If you want to excel in your career in SQL, you should refer to our SQL Course for a better understanding.

FAQs