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
- 6568 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
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How to find the number of rows in db2 tables?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Is it possible to create an Instance in DB2 using DB2 Control Center ?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Name the various locking levels available?
What is a dbrm in db2?
What is runstats utility in db2?
What is the use of with ur in db2?
What kind of database is db2?
How can record locking be achieved in those DB2 versions which do not support it?
What is node in db2?
Can there be more than one cursor open for any program?
How to view db2 table structure?
