Explain UNION,MINUS,UNION ALL, INTERSECT?
Answer / pavan_1981
UNION:set of all rows selected by both queries excluding
duplicates rows.
UNIONALL:set of all rows selected by both queries including
duplicate rows.
MINUS:set of all rows present in the first query and not
present in the second query.
INTERSECT:set of all rows commonly returned by both the
queries.
| Is This Answer Correct ? | 20 Yes | 4 No |
what are the advantages of primary key over unique+notnull
7 Answers Consultancy, LGS, Oracle,
how to select first 5 records from a table? : Sql dba
When do we create bitmap indexes
What is use of term?
Define commit?
How to fetch common records from two tables?
How do I run a pl sql program?
What do you mean by query optimization?
How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 Answers IBM, TCS, UHD,
What are aggregate and scalar functions?
Difference between IN and EXISTS
Should I use mbr or gpt?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)