what is difference between where clause and having clause?
Answer Posted / sonali
1.where clause is apply on individual row ofthe table and
having is apply on group of rows in the output of select
statement.
2.having clause is used with group by clause
3.having clause is used as a final filter on the aggregate
column values in the resultset of select statement.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why use resource manager in Oracle?
What is the difference between translate and replace?
Does oracle partitioning improve performance?
How to connect asp pages to oracle servers?
What is an anonymous block?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
defination of bitmap index
What are the varoius components of physical database structure of oracle database?
How to connect to a remote server?
What is an oracle and why it is used?
Explain a data segment?
In which language oracle has been developed?
What do you understand by a database object?
What are the different windows events activated at runtime ?
How to check your oracle database 10g xe installation?