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 nested table and how is it different from a normal table?
How to select some rows from a table in oracle?
What are ddl statements in oracle?
What is the difference between sharding and partitioning?
What is proxy method?
How to start instance with a minimal initialization parameter file?
How to loop through a cursor variable?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What are the different types of synonyms?
What are the benefits of ordbms?
What are the differences between char and nchar in oracle?
Can I create users through internet explorer in oracle 10g?
Write a syntax for update query in oracle?
what are bitmap indexes? How does they work?
Will you be able to store pictures in the database?explain.