Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36309 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
What the is the diff between local index and global index. give some example.
How to commit the current transaction in oracle?
what is Single Byte Overhead...?
What is a system tablespace?
What is program global area (pga) in oracle?
What is translate in oracle?
How to insert multiple rows with one insert statement in oracle?
How to find out what oracle odbc drivers are installed?
What privilege is needed for a user to query tables in another schema?
Briefly explain what is literal? Give an example where it can be used?
Explain the blob datatype?
What is the difference between a user and a schema in oracle?
How to use subqueries with the in operator using oracle?
How to define default values for formal parameters?
How to drop an existing table in oracle?
