wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
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 |
wht is d/f between union and joins ?
What is netezza database?
What is bufferpool in db2?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
What is dbrm? What it contains? When it will be created?
How can you find out the # of rows updated after an update statement?
Explain how can you do the explain of a dynamic sql statement?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
What types of tables are there in the db2 database?
What is auditing?
What is the information associated with sysibm.syslinks table?
What is the syntax required for the creation of a cursor?