SQL AND

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