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...

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

Answer Posted / lu

u have 2 table (a,b), u join together,u get colunms
matching it's called inner....
u have 2 tables (a,b), u select a colunm(b) doesn't exist
in a...it's called outer...
goup by using for a row...
having by using for column

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1078


What is package in cobol db2?

1121


Mention data types used in db2 ?

1166


What is runstats db2?

1042


What type of database is db2?

973


What is check constraint in db2?

1095


What is the function of logging in the db2 database?

1123


What are the rules for db2 programming?

1099


How do I create a view in db2?

1029


How would you find out the total number of rows in a db2 table?

1057


What is release/acquire in bind?

1111


What is the role of schema in the db2 database?

1279


What is db2 plan table?

1054


Define db2.

1120


What is a db2 tablespace?

1070