Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36888 Views
- I also Faced
- E-Mail Answers
Answer Posted / anto padma sheela
1. Having clause is usually used with Group By clause
although it can be used without it too.
2. 'Having' is just an additional filter to 'Where' clause.
3. 'Where' clause applies to the individual rows
whereas 'Having' clause is used to test some condition on
the group(usually aggregate methods) rather than on
individual rows.
| Is This Answer Correct ? | 28 Yes | 7 No |
Post New Answer View All Answers
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
Explain the difference between sql and oracle?
What are dml statements in oracle?
How to speed up webrick?
What is the difference between PFILE and SPFILE in Oracle?
How will you differentiate between varchar & varchar2?
What is a user account in oracle?
How to list all indexes in your schema?
How do I uninstall oracle 11g?
What is java oracle used for?
Can you tell me how to add new column in existing views?how?How is possible?
6. Display the client name and order date for all orders using the traditional method.
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Explain the difference between a procedure and a function?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
