what is difference between where clause and having clause?
- 13 Answers
- 32979 Views
- I also Faced
- E-Mail Answers
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
Can we write dml statement in function in oracle?
What is set operator oracle?
Explain the use of rows option in imp command.
Explain table?
How to speed up webrick?
What are the limitations oracle database 10g xe?
Explain the difference between a procedure and a function?
How can we find out the current date and time in oracle?
Describe varray?
What is snapshot is too old? Give and example for better understand.
Can group functions be used in the order by clause in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is PL/SQL ?
What is connection pool in oracle?
What is catalog in Oracle?
