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 8844Post New Saman Bank SQL PLSQL Interview Questions
What is a workflow? What all are its components? What is a workflow rule?
What is the function of folder?
What is the full form of adabas?
Is django faster than rails?
What is a release candidate?
Can we do pattern matching using python?
Organizational Behaviour If you are made the compaign leader for a particular political party .How will you use your leader ship skills to motivate your party men to ensure success of the party nominee in the elections? (Focus on the individual motivate and apply leadership style).
What do you need to connect php to mysql?
Explain the difference between a MapReduce InputSplit and HDFS block?
What are the different ways of deployment in salesforce? : salesforce crm
What’s selenese?
Explain Creating and Naming an Array?
What is an array in php?
What is normalisation and its type?
What os supports automation anywhere?