Write an sql query to find an employee whose salary is equal or greater than 10000.
Answers
Answered by
14
for finding only employee name
e.g.
select empname from employee
where salary>=10000
or for finding an employee record
e.g.
Select * from employee
where salary>=10000
e.g.
select empname from employee
where salary>=10000
or for finding an employee record
e.g.
Select * from employee
where salary>=10000
Answered by
11
SQL query:
SELECT EMP NAME FROM EMPLOYEE_DETAILS WHERE SALARY >=10000;
Explanation:
- Here, the table name that contains employee details is EMPLOYEE_DETAILS.
- Here the attributes are EMP NAME – contains names of the employees
- The attribute SALARY – contains salaries of the employees
The question is about finding the employee name whose salary is equal to greater than 10,000. So, to get the employee name, the SELECT command is used. If we have to select all the details rather then selecting name alone, then SELECT * will be used.
Similar questions