What is different between union and minus?
Answer Posted / humayun quaiser
unoin:- This operator returns from all the queries(combined
through union) but not duplicate record will be display.
ex- A={1,2,3,4}
B={2,3,4,5}
AUB={1,2,3,4,5}............
Minus:- This operator displays records which belongs to only
the first query.
ex:- A={1,2,3,4}
B= {2,3,5}
A-B={1,4}...................
Is This Answer Correct ? | 24 Yes | 0 No |
Post New Answer View All Answers
What are the two characteristics of a primary key?
Is sql dba a good career? : SQL DBA
What is a stored procedure in sql with example?
What are types of joins?
what is the difference between myisam static and myisam dynamic? : Sql dba
Can we create index on primary key?
What is secondary key?
What are the most important ddl statements in sql?
how can we know the count/number of elements of an array? : Sql dba
What is compound trigger?
Can a commit statement be executed as part of a trigger?
Is truncate ddl or dml?
How do you optimize a query?
How to assign sql query results to pl sql variables?
What does where 1/2 mean in sql?