What is the difference between Union, Unionall ?



What is the difference between Union, Unionall ?..

Answer / sangeeta

Union will not display the redundant data whereas UnionAll
will display the redundant data.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More JDBC Interview Questions

How many packages are available in jdbc api?

0 Answers  


Difference between Generic Servlet and HTTP Servlet?

13 Answers  


How can I connect mysql or oracle with java?

0 Answers  


What does jdbc setmaxrows method do?

0 Answers  


Where is ojdbc14 jar located?

0 Answers  






What is CLOB and BLOB datatypes in JDBC?

0 Answers  


Give me some example for getting connection from connection pooling in JBoss Server. Is Connection Pool default in Server or we have to create it? Who can create Connection Pool in a Team. How it will be accessed by the developer code?

1 Answers   TCS,


Can you define a foreign key, with a key from the same table?

2 Answers   IBM,


Is there another way of dealing with the result set that could execute faster?

0 Answers  


What are types of resultset?

0 Answers  


What is an SQL Locator?

0 Answers  


What is jdbc type?

0 Answers  


Categories