Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36543 Views
- I also Faced
- E-Mail Answers
Answer Posted / anant chavda
Þ The WHERE clause excludes rows that do not meet its
search conditions
Þ The GROUP BY clause collects rows that met the WHERE
clause search conditions and places those rows into a group
for each unique value in the GROUP BY clause. Omitting the
GROUP BY clause creates a single group for the whole table.
Þ The HAVING clause excludes groups that do not meet
its conditions. For example: When a query includes a GROUP
BY clause, the HAVING clause excludes groups from the
results. A SELECT statement containing a HAVING clause
without a GROUP BY clause will process the result as one
whole set. Aggregate functions specified in the select_list
calculate summary values for each surviving group.
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
How do I connect to oracle database?
How to specify default values in insert statement using oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What are the roles of dba?
Why does Oracle not permit the use of PCTUSED with indexes?
How to retrieve data from an cursor to a record?
How to define an anonymous procedure without variables?
How to drop a tablespace?
What do you understand by a database object? Can you list a few of them?
How to find the duplicate rows count from employees table in oracle?
What is a nvl function? How can it be used?
How to run the anonymous block again?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Is it possible to insert comments into sql statements return in the data model editor ?
How do I reset a sequence in oracle?
