Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 35945 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
can anyody please send me the dump for Oracle 10g certifications for DBA path?
State and explain about oracle instance?
How to pass parameters to procedures in oracle?
What is the disadvantage of User defind function?
Explain the use of rows option in exp command.
What is a tns file?
What are the different oracle database objects?
What is execute immediate in oracle?
How to lock and unlock a user account in oracle?
Can we create database in oracle using command line ?
Can I create users through internet explorer in oracle 10g?
How to join two tables in a single query using oracle?
What is a table index in oracle?
What is a system tablespace?
How a database is related to tablespaces?
