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 are the drivers in mysql? : Sql dba
How show all rows in sql?
What is sqlexception in java?
What is a native sql query?
What is serial sql?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
How to add new employee details in an employee_details table with the following details
how is exception handling handled in mysql? : Sql dba
what is cursor. write example of it. What are the attributes of cursor.
How many clustered indexes can be created on a table?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Can we use commit inside a trigger?
Write the alter statement to enable all the triggers on the t.students table.
What are the types of keys?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba