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
What is isolation level in db2?
What is db2 and what is the use of db2 optimizer?
What is the meaning concurrency in the db2 database?
What is deadlock in db2?
How do you stop a db2 database in linux?
List down the types of triggers in the db2 database?
Why do we use cursor?
What is the physical storage length of the data types date, time, and timestamp?
Explain about rct in db2?
What is db2 plan table?
Is db2 relational database?
What is null indicator in cobol db2?
What is the picture clause of null indicator variable?
What is db2 purescale?
What is the connection string to connect to the DB2 Database ?