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
What are the various types of snapshots ?
How do I know if oracle is installed on windows?
What are the attributes that are found in a cursor?
How to select some rows from a table in oracle?
What is index-organized table in Oracle?
How a database is related to tablespaces?
How do I recompile a procedure in oracle?
Which is better Oracle or MS SQL? Why?
How to join two tables in a single query using oracle?
How to use "out" parameter properly?
How do you bind variables in oracle?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to bring a tablespace online?
How to build data dictionary view an new database?
What are the differences between blob and clob in oracle?