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

What is isolation level in db2?

571


What is db2 and what is the use of db2 optimizer?

639


What is the meaning concurrency in the db2 database?

626


What is deadlock in db2?

572


How do you stop a db2 database in linux?

558






List down the types of triggers in the db2 database?

579


Why do we use cursor?

584


What is the physical storage length of the data types date, time, and timestamp?

593


Explain about rct in db2?

627


What is db2 plan table?

608


Is db2 relational database?

560


What is null indicator in cobol db2?

571


What is the picture clause of null indicator variable?

680


What is db2 purescale?

537


What is the connection string to connect to the DB2 Database ?

606