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?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a server parameter file?

1079


Explain drop constraint oracle?

988


In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1787


What is key preserved table?

955


How to build data dictionary view an new database?

957


What is oracle host variable?

979


Can a formula column referred to columns in higher group ?

2455


what is normalisation?what are its uses?

2206


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2172


What is the parameter mode that can be passed to a procedure?

978


Explain alias?

1077


Compare and contrast between sql and sql server and explain its various functions?

915


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2092


What is varray?

1031


Can you tell me how to add new column in existing views?how?How is possible?

1369