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 7649Post New Saman Bank SQL PLSQL Interview Questions
-
Saman Bank SQL PLSQL Interview Questions (1)
What is ctrl g?
What is the special meaning of __sleep and __wakeup?
Who is covered by the FLSA? Are employees of small businesses covered?
What is represented by the connection object?
Can we start a thread twice in java?
Why ide is recommended for use while programming with php?
What are Model Binders in ASP.Net MVC?
What is prepared statement in mysql?
What are the different kinds of ssrs reports?
What is file access opcodes?
What are the views available in the quick launch of information modeler? : hana modeling
How do I open a pgadmin file in windows?
Draw a P& ID showing – orifice flange, plate, dp transmitter, isolation & bypass valves and tubing.
In a VPC how many EC2 instances, you can use?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
