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


Please Help Members By Posting Answers For Below Questions

Explain self joins in oracle?

653


What are the different types of partitions in oracle?

582


Can we create database in oracle using command line ?

664


defination of bitmap index

1715


How to select an oracle system id (sid)?

668






How to start your 10g xe server?

686


How to loop through a cursor variable?

669


what are steps for interface? where is exchange rate defined in which table?

1593


How to drop an existing view in oracle?

648


Difference between open_form and call_form in oracle.

786


How to create a server parameter file?

656


What is flashback in Oracle?

663


How to work with data objects interactively?

634


What are a collation and state the different types of collation sensitivity?

644


List the parts of a database trigger.

680