Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36901 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 create an oracle testing table?
How to rename an index?
How does Oracle guarantee data integrity of data changes?
What is the data pump export utility?
what are bitmap indexes? How does they work?
How to view the data files in the current database?
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
Explain oracle insert into command?
How are the index updates?
How do I know if oracle is installed on windows?
What is literal?
What is pragma autonomous transaction in oracle?
Oracle General 
