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
- 6674 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinivasa yadav
INNER JOIN: ALL THE MATCHED ROWS FROM BOTH THE TABLES ARE
DISPLAYED IN THE RESULTANT TABLE.
OUTER JOIN: THERE ARE THREE TYPES OF OUTER JOIN
THEY ARE
1)LEFT OUTER JOIN
2)RIGHT OUTER JOIN
3)FULL OUTER JOIN
LEFT OUTER JOIN:- ALL THE MATCHED AND UNMATCHED ROWS FROM
BOTH TABLES FROM THE LEFT TABLE ARE DISPLAYED IN THE
RESULTANT TABLES
RIGHT OUTER JOIN:- ALL THE MATCHED AND UNMATCHED ROWS FROM
BOTH RIGHT TABLE ARE DISPLAYED IN THE RESULTANT TABLE.
FULL OUTER JOIN:- ALL THE MATCHED AND UNMATCHED ROWS FROM
BOTH THE TABLES ARE DISPLAYED IN THE RESULTANT TABLE.
GROUP BY CLAUSE:- IT IS USED ON GROUP OF DATA AND PROCESS AN
SQL QUERY.
ORDER BY:- IT IS USED TO SORT THE DATA IN ASCENDING OR
DESCENDING ORDER.
EX:- SELECT EMPID FROM EMP_TBL ORDER BY
DSC (OR) ORDER BY 1.
ORDER BY 1 i.e THE COLUMN NUMBER (EMPID)
HAVING BY:- IT IS USED FOR CONDITION CHECKING.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / 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 |
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
How does cobol compile db2 program?
What are the two types of logging in the db2 database? Explain them.
can i code union in cobol-db2 pgm ?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
Explain about cursor stability?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
What is coalesce in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How do I change the column size in db2?
What is bind and rebind in db2?
COBOL 
