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

How are jdbc statements used?

0 Answers  


What are the steps to connect to a database in java?

0 Answers  


What are drivers available?

0 Answers  


Why do you use a data source object for a connection?

0 Answers  


What is jdbc driver manager?

0 Answers  






What are different types of JDBC Drivers?

0 Answers  


Explain some new features available in jdbc 4.0?

0 Answers  


How can we retrieve data from the resultset?

0 Answers  


What is new in JDBC 2.0?

0 Answers  


What are the different classes through which JDBC represents statements?

0 Answers  


If you are given a choice to implement the code to either insert a record or update if already exist, which approach will you follow ?

0 Answers  


What is isolation level? How to set it?

0 Answers   FGG,


Categories