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
- 6533 Views
- I also Faced
- E-Mail Answers
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
How to retrieve rows from a db2 table in embedded sql?
What r the comman abends in db2, jcl and cobol???????
How do I create a view in db2?
How to fetch the last row from the table in SQL (db2)?
Can there be more than one cursor open for any program?
Explain dclgen.
What is coalesce in db2?
What is the maximum No of rows per page?
When the like statement is used?
Before you give the explain statement, what are the prerogatives?
What is temporal table in db2?
How would the varchar column remarks defined?
What are union and union all?
On which levels locks can be applied?
How can we retrieve the total number of records in RPG & CLLE?
