What is the difference between Minus, and Intersect?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What does jdbc do?

525


Is jdbc faster than hibernate?

568


What is a statement?

576


Where is jdbc used?

486


Is jdbc an api?

503






Explain the steps in writing a java program using jdbc?

446


How can you retrieve data from the resultset using jdbc?

549


Is jdbc object oriented?

498


Which type of JDBC driver is the fastest one?

568


How many types of JDBC Drivers are present and what are they?

500


How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?

585


What is a jdbc url?

461


What do you mean by database connection pooling?

514


How can I instantiate and load a new CachedRowSet object from a non-JDBC source?

530


What is jdbc odbc in java?

529