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 8674Post New Saman Bank Interview Questions
What are the new features in c# 2.0?
What is processing candidates process?
What is procedure in database?
What is the force exerted by the tacoma narrows bridge?
Explain the usage of the crmv_event framework?
Can you use MathML tags directly in HTML5 without any plugin?
What are the steps required for setting up validator framework in struts?
describe types of customers you often contact at work
What is the difference between snapshot and ami?
Write the 10 high test cases for making video call/face time?? Write the test cases for credit card accessing the money transfer?? Write the test cases for file transfer from one user to other from Google Drive/drop box?
Define "correlated subqueries".
What is data cleansing?
What is the use of features?
what are the aspects an auditor has to see when he/she is doing the Purchase,Sales and Journal Vouching
What is Scala anonymous function?