What is the difference between join and union.
Answer Posted / preeti mishra
Join:- Joins are used to query data from two or more
tables, based on a relationship between certain columns in
these tables.
Union:- UNION operator combines two or more SELECT
statements.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
how do you tune the slow running queries in oracle db , explain the methodology
What is an ndf file?
How do you write a subquery?
Is sqlite free?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is the difference between partition and index?
What is the purpose of the partition table?
Why truncate is used in sql?
What is procedure explain with program?
What is before and after trigger?
How do I partition a table in sql?
Can pl sql procedure have a return statement?
What is pl sql architecture?
How many commands are in sql?
Which sql statement is used to return only different values?