what is difference between where clause and having clause?
- 13 Answers
- 33000 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Explain an integrity constrains?
What is oracle latest version?
How to define a variable of a specific record type?
What is Segment Advisor in Oracle?
What is the implicit cursor in oracle?
How to write date and time interval literals in oracle?
What is where clause in oracle?
Explain index?
What privilege is needed for a user to create indexes in oracle?
What is a cursor in oracle?
What is partitioned table in Oracle?
Why do we use coalesce function in oracle?
How to load data from external tables to regular tables?
How does oracle handle read consistency?
