Blue Shark he is right but the union O/P is wrong 1 hammer 3 $ 1 2 sc

What is the difference between join and union.

Question Posted / krish

27 Answers
181269 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

Please Help Members By Posting Answers For Below Questions

Does pl sql work in mysql?

1033

What is user in sql?

1071

How to change the order of columns in Oracle SQL Plus ?

1100

How do you optimize a stored procedure in sql?

1014

How do I find duplicates in two columns?

1260

Can we change the table name in sql?

994

What is the purpose of primary key?

1070

How many types of relationship are there?

1080

Explain the purpose of %type and %rowtype data types?

973

is it possible to pass an object or table to a procedure as an argument?

1176

How do you sort in sql?

1065

What is sql procedures and functions?

1071

Write a sql query to convert all character to uppercase after hypen.

1484

how to show all tables with 'mysql'? : Sql dba

1155

what is a trigger? : Sql dba

1085