wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
Answer Posted / 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 |
Post New Answer View All Answers
What is catalog database in db2?
What is ibm db2 database?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Explain about rct.
What is difference between rollback and commit?
What is rebind in db2?
List out the three types of page locks that can be held.
What does sqlcabc has?
What is a db2 cursor?
On which levels locks can be applied?
What is the maximum number of columns in a db2 table?
What are the 2 sqlcodes that are returned?
What is collection in db2 bind?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is the use of commit in db2?