Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36539 Views
- I also Faced
- E-Mail Answers
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 |
How to use "out" parameter properly?
What is a sub query? Describe its types?
What is a deadlock ? Explain .
What are internal user account in oracle?
How does oracle handle read consistency?
How to execute a stored program unit?
How do I call oracle stored procedures that take no parameters?
What is Row Chaining ?
What is the difference between translate and replace?
How to drop an existing view in oracle?
How to use values from other tables in update statements using oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
Oracle General 
