What is the difference between join and union.
Answer Posted / krish
Blue Shark
he is right but the union O/P
is wrong
1 hammer 3 $ 1
2 screwdriver 5 $ 2
this is right
it won't select duplicates
union all will do.
thanks
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a recursive stored procedure?
Can sql function call stored procedure?
What is the size of partition table?
Can a composite key be null?
What are the types of views in sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
How to start the command-line sql*plus?
What is the starting oracle error number?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What is sql lookup?
how to shut down the server with 'mysqladmin'? : Sql dba
Can you upgrade sql express to full sql?
Can primary key be changed?
What is trigger in sql?
How does postgresql compare to mysql?