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
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is package in cobol db2?
Mention data types used in db2 ?
What is runstats db2?
What type of database is db2?
What is check constraint in db2?
What is the function of logging in the db2 database?
What are the rules for db2 programming?
How do I create a view in db2?
How would you find out the total number of rows in a db2 table?
What is release/acquire in bind?
What is the role of schema in the db2 database?
What is db2 plan table?
Define db2.
What is a db2 tablespace?