what is difference between where clause and having clause?
Answer Posted / arkchowdary
Where Clause------------------ It is used to Filter Rows
(i.e Restrict Rows and It appiles to the Individual Rows).
Having Clause----------------- It appies on Groups (i.e
Aggregate Functions).
| Is This Answer Correct ? | 23 Yes | 3 No |
Post New Answer View All Answers
What is a dynamic performance view in oracle?
Explain about achiever in sql?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to add a new column to an existing table in oracle?
How to run the anonymous block again?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How can we force the database to use the user specified rollback segment?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How a tablespace is related to data files?
How to check the oracle tns settings?
How to connect asp pages to oracle servers?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the attributes of cursor?
Explain the use of indexes option in imp command.
How to define an oracle sub procedure?