WHERE clause is used to fetch records based on certain condition.
Syntax:
SELECT * FROM TABLE_NAME WHERE condition
Example:
There is created “Employee” Table.
The following query will fetch records from “Employee” Table whose salary greater than equal to 20000.
SELECT * FROM Employee WHERE Salary >= 20000
Output :
Note : This clause is used in all DML statements(SELECT,INSERT,DELETE,UPDATE)
Having clause is used to fetch records based on certain condition with Group by clause.
Having clause can not be use without Group by Clause.
Syntax:
SELECT column1,column2 FROM TABLE_NAME
WHERE condition Group by column1
Having condition
The following query will fetch records from “Employee” Table whose sum of salary greater than equal to 10000.
SELECT ID, Sum(SALARY)
FROM employee
GROUP BY ID
HAVING Sum(SALARY)>10000
Output :
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.