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
How to view the data files in the current database?
How to commit the current transaction in oracle?
How to do clean up if create database failed?
What are the limitations oracle database 10g xe?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How to add another datafile to a tablespace?
Whats the benefit of dbms_stats over analyze?
What is bulk copy or bcp in oracle?
How to create a single index for multiple columns?
What is the difference between PFILE and SPFILE in Oracle?
What is the disadvantage of User defind function?
How can we find out the current date and time in oracle?
What is the difference between postgresql and oracle?
How different is ms access and oracle?
What is a relational database management system?