CUSTOMERS table WHERE Clause I ID I NAME AGEADDRESS SALARY 1 Ramesh 32 Ahmedabad 2999.98 2 Khian 25 Delhi 1598.09 SELECT column1, column2, columnN 3 kaushik 23Kota 2998.99 FRoM table name 4 Chaitali 25 Mumbai 6599.98 WHERE [condition] 5 Hardik 27 Bhopal 8598.09 6Komal 4589.99 7 Muffy 24 Indore 19999.99 一----十- Fetch ID, Name and salary fields from the CUSTOMERS table where salary is greater than 2000 IDNAME SALARY 4 Chaitali 6599.09 SELECT ID, NAME SALARY 5 Hardik 8599.99 FROM CUSTOMERS 6 Komal 4589.99 WHERE SALARY>2000; 7 Muff 19999.99 Fetch ID, Name and Salary fields from the CUSTOMERS table for a customer with name hardik SELECt ID, NAME SALARY ID NAME SALARY FROM CUSTOMERS -=-+ WHERE NAME = Hardik; 5| Hardik|8500.00 http://ww.tutorialspoint.com/sqlsql-where-clause.htmWHERE Clause 33 SELECT column1, column2, columnN FROM table_name WHERE [condition] +----+----------+-----+-----------+----------+ | ID | NAME | AGE | ADDRESS | SALARY | +----+----------+-----+-----------+----------+ | 1 | Ramesh | 32 | Ahmedabad | 2000.00 | | 2 | Khilan | 25 | Delhi | 1500.00 | | 3 | kaushik | 23 | Kota | 2000.00 | | 4 | Chaitali | 25 | Mumbai | 6500.00 | | 5 | Hardik | 27 | Bhopal | 8500.00 | | 6 | Komal | 22 | MP | 4500.00 | | 7 | Muffy | 24 | Indore | 10000.00 | +----+----------+-----+-----------+----------+ SELECT ID, NAME, SALARY FROM CUSTOMERS WHERE SALARY > 2000; +----+----------+----------+ | ID | NAME | SALARY | +----+----------+----------+ | 4 | Chaitali | 6500.00 | | 5 | Hardik | 8500.00 | | 6 | Komal | 4500.00 | | 7 | Muffy | 10000.00 | +----+----------+----------+ • Fetch ID, Name and Salary fields from the CUSTOMERS table where salary is greater than 2000: SELECT ID, NAME, SALARY FROM CUSTOMERS WHERE NAME = 'Hardik'; +----+----------+----------+ | ID | NAME | SALARY | +----+----------+----------+ | 5 | Hardik | 8500.00 | +----+----------+----------+ CUSTOMERS table • Fetch ID, Name and Salary fields from the CUSTOMERS table for a customer with name Hardik http://www.tutorialspoint.com/sql/sql-where-clause.htm