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 a partition in oracle?
Explain rename?
What is ASM (Automatic Storage Management) in Oracle?
What do database buffers contain?
Explain cascading triggers.
Difference between cartesian join and cross join?
Explain index?
How to use "startup" command to start default instance?
Does oracle charge for java?
How to create a table index?
what is port in oracle? how is it related to database application.
What is an oracle table?
How to define a procedure inside another procedure?
How can we create the complete backup of data in the oracle.
Which is faster join or subquery in oracle?