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
Explain the structure of pl/sql in brief.
what are integrity rules?
Where do we use pl sql?
what is self join and what is the requirement of self join? : Sql dba
What is function and procedure in pl sql?
How to check if a column is nullable before setting to nullable?
What is a procedure in pl sql?
Can you upgrade sql express to full sql?
what is a database? : Sql dba
How does left join work in sql?
What is the difference between subquery and correlated query?
Is sql a microsoft product?
Mention what pl/sql package consists of?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What is a sql statement?