Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36325 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 connect asp pages to oracle servers?
What is Undo Management Advisor in Oracle?
What is the relation of a user account and a schema in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad
How to define Data Block size ?
What is varray?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is index-organized table in Oracle?
What is SYSTEM tablespace and When is it Created?
Where do you use decode and case statements?
Oracle General 
