Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 179606 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
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 the difference between database trigger and stored procedure?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
State some properties of relational databases?
What is group function in sql?
What is sql procedures and functions?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What does stand for in sql?
how tsql statements can be written and submitted to the database engine? : Transact sql
what are integrity rules?
What is pl sql and why it is used for?
how can we destroy the cookie? : Sql dba
What is sap sql?
What is difference between left and right outer join?
What are the subsets of sql?
Is sql a programming?
