What is the difference between Minus, and Intersect?



What is the difference between Minus, and Intersect?..

Answer / subrahmanyam

Minus in sql two quest displays all the recorder of first
query removing comon records from both queries



Intesect return only the common records

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More JDBC Interview Questions

what exactly happens when we execute "Class.forname("Driver class name");"?Explain indetail

10 Answers   Accenture, HP, IBM, Infosys, SAP Labs, SAS, Sasken, Trigent, Wipro,


Why “no suitable driver” error occurs?

0 Answers  


What is JDBC and ODBC and what are the differences between them?

11 Answers   Idbi Bank, Infosys, Infoview, TCS,


what are design patterns?

3 Answers   CFC, TCS, Wipro,


What does the jdbc connection interface?

0 Answers  






How can we maintain the integrity of a database by using jdbc?

0 Answers  


What are the measures to connect to the db using jdbc?

0 Answers  


What do you mean by database connection pooling?

0 Answers  


Why do we use jdbc statements?

0 Answers  


what is the meaning of following code snippets Class c=class.forName(driverClassName); Driver d=(driver)c.newInstance();

1 Answers  


How to make updates to updatable result sets in jdbc?

0 Answers  


What is jdbc drivers in java?

0 Answers  


Categories