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 / mrityunjay kumar dubey

A WHERE Clause is used to restrict a row and HAVING Clause is used to restrict a group.WHERE Clause can be used for specifying the search criteria in SELECT, DELETE, UPDATE statements.HAVING Clause is used when GROUP BY Clause is used.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2187


What is the difference between online and offline backups?

1135


hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2422


How many types of synonyms in Oracle?

1180


How to revoke create session privilege from a user in oracle?

1068


What happens to the current transaction if a ddl statement is executed?

1059


What is using clause and give example?

1109


What is an oracle recycle bin?

1064


What is the difference between substr & instr functions?

1295


Explain rename?

1046


What is an oracle user role?

1041


How to see free space of each tablespace?

1083


what is port in oracle? how is it related to database application.

1992


What is memory advisor in Oracle?

1134


What is translate in oracle?

1145