What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.
2 7880Post New Saman Bank Interview Questions
What is a package ? What are the advantages of package ?
What are the essential attributes in image tag in html?
Who invented power point?
Is activex secure?
What are the differences between hash join, merge join and nested loops?
hi i would like to know is there any training institue for Calabash,robotium and ui automator in hyderabad...urgent
My Apologies, The previous questions were concerning the Transaction ST02
How the plants can survive in Tundra where temperature reaches -57oC?
Explain what are the mapping paramaters and maping variables?
Is SAP Business Objects offered as independent BI solutions or is it tied with SAP?
What is late binding?
What is runtimebroker exe?
How many rows are there in excel 2007?
I have motor of 3 H.P. How i found the rating of capacitor use in it in single phase motor..???
What is the use of lambda in c++?