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 to select some columns from a table in oracle?
Write a trigger example in oracle?
What privilege is needed for a user to query tables in another schema?
How to convert numbers to characters in oracle?
Explain what are the advantages of views?
Explain the types of exception?
What is a proxy class?
Why should I use oracle database?
Explain the use of owner option in exp command.
Why do you create or replace procedures rather that drop and recreate.
How to start your 10g xe server from command line?
Explain the difference between a procedure and a function? What do you understand by those terms?
How to install oracle database 10g xe?
What is blob data type in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?