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
How to change sql*plus system settings?
What are the types of sql commands?
What is pl/sql table? Why is it used?
What are the types of join and explain each?
Define overloaded procedure?
Can you call pl/sql package functions from within a fast formula?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is the use of stored procedures?
Explain the savepoint statement.
What does dml mean?
What is a database? Explain
discuss about myisam key cache. : Sql dba
Show the two pl/sql cursor exceptions.
What is substitution variable in pl sql?
How delete all data from all tables in sql?