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 |
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
Do View contain Data ?
What is an oracle recycle bin?
What is the difference between truncate & delete command?
State the various uses of dbcc command?
How to display row numbers with the records?
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
How to see free space of each tablespace?
List the types of joins used in writing subqueries?
How to drop a stored procedure in oracle?