what is the difference between union and union all
Answer Posted / srinivas
Another difference is that union will sort the result sets
whereas union all will not.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
what is the syntax used for partition in tsql? : Transact sql
How can you save or place your msg in a table?
what are the different tables present in mysql? : Sql dba
What is an escape character in sql?
Can we use loop in sql?
What is not equal in sql?
How delete all data from table in sql?
Which nosql database is best?
write an sql query to find names of employee start with 'a'? : Sql dba
How does an execution block start and end in pl sql?
What is rowid in sql?
what are the security recommendations while using mysql? : Sql dba
how to convert numeric values to character strings? : Sql dba
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
Does sql backup shrink transaction log?