Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is difference between where clause and having clause?

Answers were Sorted based on User's Feedback



what is difference between where clause and having clause?..

Answer / shashikant

in 'where' clause every records filtered based on where
in 'having' is with aggregate records (group by functions )

Is This Answer Correct ?    44 Yes 5 No

what is difference between where clause and having clause?..

Answer / narender sharma

Where clause is used to restrict rows but having clause is
used to restrict groups

Is This Answer Correct ?    28 Yes 3 No

what is difference between where clause and having clause?..

Answer / 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

what is difference between where clause and having clause?..

Answer / 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

what is difference between where clause and having clause?..

Answer / suga priya

query:WHERE DEPARTMENT > 333


query:HAVING AVG(SALARY) > 50000.

Is This Answer Correct ?    18 Yes 4 No

what is difference between where clause and having clause?..

Answer / yogesh babu

where is also similar to that of where clause used ina
query ... But this search filter is used while using a
groupby clause

Is This Answer Correct ?    10 Yes 3 No

what is difference between where clause and having clause?..

Answer / 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 ?    14 Yes 8 No

what is difference between where clause and having clause?..

Answer / sonali

1.where clause is apply on individual row ofthe table and
having is apply on group of rows in the output of select
statement.
2.having clause is used with group by clause
3.having clause is used as a final filter on the aggregate
column values in the resultset of select statement.

Is This Answer Correct ?    2 Yes 0 No

what is difference between where clause and having clause?..

Answer / anant chavda

Þ The WHERE clause excludes rows that do not meet its
search conditions

Þ The GROUP BY clause collects rows that met the WHERE
clause search conditions and places those rows into a group
for each unique value in the GROUP BY clause. Omitting the
GROUP BY clause creates a single group for the whole table.

Þ The HAVING clause excludes groups that do not meet
its conditions. For example: When a query includes a GROUP
BY clause, the HAVING clause excludes groups from the
results. A SELECT statement containing a HAVING clause
without a GROUP BY clause will process the result as one
whole set. Aggregate functions specified in the select_list
calculate summary values for each surviving group.

Is This Answer Correct ?    5 Yes 4 No

what is difference between where clause and having clause?..

Answer / 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

More Oracle General Interview Questions

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

0 Answers  


What is open database communication (odbc) in oracle?

0 Answers  


How many types of auditing in Oracle?

0 Answers   MCN Solutions,


in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

3 Answers   Polaris,


difference between procedures and function?

7 Answers   IBM,


can you explain performance tunning in oracle(sql,PL/SQL)

2 Answers  


What are the Referential actions supported by FOREIGN KEY integrity constraint ?

1 Answers  


What is merge statement used for?

0 Answers  


A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

3 Answers  


Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

1 Answers   IBM,


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

0 Answers   IBM,


how to insert data into partitioned table partition done by Range partition

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)