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 ?
- 2 Answers
- 6430 Views
- I also Faced
- E-Mail Answers
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
Which components manage deadlocks in db2?
What is difference between isnull and coalesce?
How can you find out the # of rows updated after an update statement?
Why do we bind in db2?
How can the duplicate values be eliminated from db2 select?
What is db2 catalog database?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is the default page size of buffer pools?
Can you use max on a char column?
What is rct?
What is the advantage in De-normalizing tables in DB2?
What is cursor with hold option in db2?
What is ibm db2 used for?
What is load replace in db2?
can all users have the privilage to use the sql statement select * (dml)?
