WHERE clause is used to fetch records based on certain condition.
SELECT * FROM TABLE_NAME WHERE condition
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
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.
SELECT column1,column2 FROM TABLE_NAME
WHERE condition Group by column1
The following query will fetch records from “Employee” Table whose sum of salary greater than equal to 10000.
SELECT ID, Sum(SALARY)
GROUP BY ID
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.