what is differece between union and union all

Answer Posted / ramesh raja

UNION: combine distinct values between two tables
UNION ALL : combine all values and also duplicates values
between the two tables

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is row_number()?

598


How to create a simple user defined function in ms sql server?

555


What is sql language?

561


What is acid mean in sql server?

587


How is foreign key related to primary key?

587






what are the reporting service components in SSRS?

118


How can sql server instances be hidden?

532


What are the types of containers in ssis?

611


What is the difference between row_number and dense_rank?

451


What are the requirements for sql server 2016?

548


What is the library index called?

608


How do I view a stored procedure in sql server?

527


What is logon trigger?

558


Explain isolation levels that sql server supports?

584


Define master database?

594