what is difference between where clause and having clause?
Answers were Sorted based on User's Feedback
Answer / mrityunjay kumar dubey
A WHERE Clause is used to restrict a row and HAVING Clause is used to restrict a group.WHERE Clause can be used for specifying the search criteria in SELECT, DELETE, UPDATE statements.HAVING Clause is used when GROUP BY Clause is used.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / manvendra
RISTRICT GROUP BY FUNCTION BY HAVING.
RESTRICT NORMAL QUERY BY WHERE.
YOU CAN PUT WHERE AND HAVING IN A QUERY.
| Is This Answer Correct ? | 14 Yes | 21 No |
Answer / pawan
HAVING clause is used only with GROUP functions whereas
WHERE clause we can use with both.
| Is This Answer Correct ? | 8 Yes | 15 No |
What is the meaning of recursive hints in oracle?
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
What is a proxy class?
What happens if you use a wrong connect identifier?
There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep
What is an oracle tablespace?
How to convert csv to table in oracle?
Explain the use of tables option in exp command.
Calculate difference between 2 date / times in oracle sql?
Can Multiple instances be run on Single Machine???
What is a database schema in oracle?
How to write text literals in oracle?