What is the difference between join and union.
- 27 Answers
- 172826 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
Why do we go for stored procedures?
What is asqueryable?
What are the advantages of sql?
Why do we use set serveroutput on?
What is cost in sql execution plan?
How to get list of all tables from a database?
What is the usage of the distinct keyword?
Can we connect to postgresql using sql developer?
What is scalar function in sql?
How many types of cursors supported in pl/sql?
What is the file extension for sql database?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
How to know the last executed procedure?
How subquery works in sql?
What are sql objects?
