Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36908 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 is execute immediate in oracle?
What is a subquery in oracle?
What would you do with an in-doubt distributed transaction?
What is a cursor in oracle?
Can we store pictures in the database and if so, how it can be done?
What is a schema in oracle?
What is Virtual Private Database in Oracle?
How to find the duplicate rows count from employees table in oracle?
How can we find out the current date and time in oracle?
How can we delete duplicate rows in a table?
What is a dynamic performance view in oracle?
Explain the types of exception?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How many types of tables are there in oracle?
Use of an integrity constraint is better to validate data. Explain
