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 the difference between Where and Having Clause

Answer Posted / s

WHERE filters the rows based on the predicate.
HAVING filters a group of rows based on the GROUP BY colums.

Is This Answer Correct ?    48 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What db2 400?

1206


How to view db2 table structure?

1023


How can we retrieve the total number of records in RPG & CLLE?

661


How do you pull up a query which was previously saved in qmf?

1160


How is a typical db2 batch pgm executed?

1185


What do you mean by storage group (stogroup)?

1047


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1068


Where can you declare a cursor in a cobol-db2 program?

1085


Are views updateable?

1168


What is runstats utility in db2?

1029


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2188


What is the result of open cursor statement?

1087


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1083


What does db2 mean?

1025


How do I copy a table in db2?

1008