what is difference between where clause and having clause?
Answer Posted / suga priya
query:WHERE DEPARTMENT > 333
query:HAVING AVG(SALARY) > 50000.
Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
What is the difference between a user and a schema in oracle?
How to define a data source name (dsn) in odbc manager?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to get a list of all background sessions in the database?
Does oracle database need java?
Can we create trigger on materialized view in oracle?
How to build data dictionary view an new database?
what is meant by magic query
Name the various constraints used in oracle?
What privilege is needed for a user to create indexes in oracle?
Explain the features of oracle?
What are the types of trigger in oracle?
How to use fetch statement in a loop?
How to retrieve data from an explicit cursor?
Explain a synonym?