Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36906 Views
- I also Faced
- E-Mail Answers
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
Name the various constraints used in oracle?
What are the ways tablespaces can be managed and how do they differ?
How to sort output in descending order in oracle?
Explain oracle’s server parameter file.
What are the different types of partitions in oracle?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
In oracle there is column command, how will you explain that?
How many types of tables are there in oracle?
How would you change old and new values in an insert, delete and update triggers?
What is materialized view in Oracle?
How to rebuild an index in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to assign a tablespace to a users in oracle?
How to assign a table row to a record variable?
What is parameterized cursor in oracle?
