What is the difference between Union, Unionall ?

Question Posted / guest

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

More JDBC Interview Questions

What is JDBC Batch Processing and what are it’s benefits?

How do I know which jdbc driver to use?

What are the different types of statements in jdbc?

What is the difference between ojdbc6 and ojdbc7?

What are different types of ResultSet?

password, is stored in as plain text. What can I do to protect my passwords?

Explain creation of statement object with connection method create method with help of an example.

Does jdbctemplate close connection?

How do I insert an image file (or other raw data) into a database?

What are the functions of the jdbc connection interface?

how to prevent finally block from execution

What are the differences between setmaxrows(int) and setfetchsize(int)?

For more JDBC Interview Questions Click Here