what is difference between where clause and having clause?
Answer Posted / rajesh dutta
where conditions used only for comparing row values.
having conditions used to compares group values like
min,max,count etc.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How can I see all tables in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is the difference between view and materialized view in Oracle?
How many types of cluster table in Oracle?
What is a nested table and how is it different from a normal table?
How to convert a string to a date in oracle database?
various types of hints and their usage
What is the best way to do multi-row insert in oracle?
What are the restrictions on external table columns?
Can we write insert statement in function in oracle?
What are the components of logical database structure in oracle database?
What are the benefits of ordbms?
What suggestions do you have to reduce the network traffic?
what are the default admin accounts in Oracle 10g ?