what is the difference between union and union all
Answer Posted / suresh
union is used to select distinct values from two tables
where as union all is used to select all values including
duplicates from the tables
Is This Answer Correct ? | 175 Yes | 12 No |
Post New Answer View All Answers
How you improve the performance of sql*loader? : aql loader
What are the commands used in sql?
I need a function for a train ticket reservation please answer it thanks in advance
What does select * from mean in sql?
Is primary key an index?
What are keys in sql?
Why stored procedure is faster than query?
What is foreign key in sql with example?
What are character functions?
is it possible to pass an object or table to a procedure as an argument?
What are the two characteristics of a primary key?
How to select all records from the table?
What is difference between rank () row_number () and dense_rank () in sql?
What is trigger and stored procedure in sql?
What is the difference between mdf and ndf files?