what is difference between where clause and having clause?
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 to convert raw data type into text in oracle? Explain
How to run queries on external tables?
List out the types of joins.
What is a proxy object?
What is a data lock in oracle?
How to convert character types to numeric types?
How can I introduce multiple conditions in like operator?
What is the difference between sharding and replication?
What is the simplest tool to run commands on oracle servers?
When do we use group by clause in a sql query?
What do you understand by a database object? Can you list a few of them?
Explain the use of owner option in exp command.
How can I create database in oracle?
How to create a stored procedure in oracle?
How to define a record variable to store a table row?