UNION gives result set of only distinct values from both tables where as U

-------------Diff b/w Union and Unionall?

Question Posted / abd hfz

Answer Posted / abd hfz

UNION gives result set of only distinct values from both
tables where as UNION ALL selects all values including
duplicates.

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is defined as catalog and types of catalogs in Cognos?

1134

what is stitch query in reportnet?

1097

What are the roles defined by cognos platform?

1142

how you provide security to reports? How you provide security to packages ?

1063

2. What functional area you worked on.

2346

Can you define dimension?

1080

Explain the difference between powerplay transformer and power play reports?

1021

what are the filters in framework manager and report studio?

990

Can you define transformer?

948

What do you mean by drill through report?

965

What is difference between page break and section report? What is main advantage datawarehousing over oracle?

1010

Can you explain dynamic query mode?

1055

How do you improve the performance of the Cognos Analytics report

1035

What is main advantage datawarehousing over oracle?

1003

What is meant by Reportstudio shortcut?

2186