Write SQL select query with AND where conditions.
The AND operator displays a record if all the conditions separated by AND are TRUE
Example
Table: Employee+----+-------+--------+--------------+| Id | Name | Salary | DepartmentId |+----+-------+--------+--------------+| 1 | Ram | 85000 | 1 || 2 | Henry | 80000 | 2 || 3 | Sam | 60000 | 2 || 4 | Shyam | 60000 | 1 || 5 | Geeta | 90000 | 1 || 6 | Sheet | 90000 | 1 || 7 | Leela | 80000 | 1 || 8 | Geeta | 70000 | 1 |+----+-------+--------+--------------+
Approach:
Mysql:
Query: Select employee who is earning more than or equal 85000 and from department 1;
SELECT * FROM EMPLOYEE WHERE SALARY>=85000 AND DEPARTMENTID=1;
Oracle:
Query: Select employee who is earning more than or equal 85000 and from department 1;
SELECT * FROM EMPLOYEE WHERE SALARY>=85000 AND DEPARTMENTID=1;
Result:
Table: Employee+----+-------+--------+--------------+| Id | Name | Salary | DepartmentId |+----+-------+--------+--------------+| 1 | Ram | 85000 | 1 || 5 | Geeta | 90000 | 1 || 6 | Sheet | 90000 | 1 |+----+-------+--------+--------------+
No comments:
Post a Comment