Jyothsna, you are correct too. Regards, Bunty

what is the difference between union and union all

Question Posted / banti

Answer Posted / banti

Jyothsna,

you are correct too.

Regards,
Bunty

Is This Answer Correct ?

19 Yes

8 No

Please Help Members By Posting Answers For Below Questions

How do you remove duplicates without using distinct in sql?

918

What is the maximum number of rows in sql table?

955

Can we use pl sql in sql server?

1011

What is cursor explain with example?

921

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1175

What is the difference between the conventional and direct path loads? : aql loader

1314

What is the difference between drop and truncate commands?

996

How to create an array in pl/sql?

1008

What is a .db file?

925

Can we use join in subquery?

1022

Is it possible for a table to have more than one foreign key?

975

What is the mutating table and constraining table?

966

Explain the methods used to protect source code of pl/sql.

958

what is the difference between clustered and non clustered index in sql? : Sql dba

1047

Does view store data in sql?

900