Interested to Buy Any Domain ? << Click Here >> for more details...
Explain UNION,MINUS,UNION ALL, INTERSECT?
- 1 Answers
- 13326 Views
- I also Faced
- E-Mail Answers
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 different type of normalization? : Sql dba
Can I create table without primary key?
What is the difference among union, minus and intersect?
How do you retrieve the last N records from a table?
How does join work in sql?
what is the functionality of the function htmlentities? : Sql dba
What is a transaction?
What is the file extension for sql database?
How would you convert date into julian date format?
What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.
Give the order of sql select?
What is the use of sqlerrd 3?
-
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)
