1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is the difference among union, minus and intersect?

Question Posted / ramesh


What is the difference among union, minus and intersect?..

Answer / Prateek Kumar Srivastava

Union combines rows from two tables where records have the same column values (ignoring duplicates). Minus removes duplicate rows based on a condition. Intersect returns only common rows between two tables where corresponding columns have the same value in both tables.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Can we create view in stored procedure?

1 Answers  

What is varchar used for?

1 Answers  

How to copy a table in another table with datas?

9 Answers  

What is latest version of sql?

1 Answers  

What is view explain with example?

1 Answers  

what is constraining table?

2 Answers  

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

Is sql dba a good career? : SQL DBA

1 Answers  

How can I make sql query run faster?

1 Answers  

What is a natural join?

1 Answers  

Which is better varchar or nvarchar?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories