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
- 6678 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
What is database reorganization?
Which isolation level provides maximum concurrency?
Can we delete records from view?
On which levels locks can be applied?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
How is a typical db2 batch pgm executed?
What is access path in db2?
How to restart a DB2 program?
What are types of indexes?
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 ?
What are the contents of a dclmgen?
Explain about rct in db2?
What does db2 blu stand for?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is check constraint. Explain with example.
