What is Difference Between Unique and Primary Key Constraints?
No Answer is Posted For this Question
Be the First to Post Answer
Can we use out parameter in function?
what happens if null values are involved in expressions? : Sql dba
how many groups of data types? : Sql dba
What are the PL/SQL Statements used in cursor processing ?
what is schema? : Sql dba
What is a trigger word?
What are the usage of SAVEPOINTS?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is pl sql in oracle?
Which version of sql do I have?
how can we optimize or increase the speed of a mysql select query? : Sql dba
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.