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

What is cursor in pl sql with examples?

1035

What is a database trigger?

1072

Why do we use procedures?

963

Show the cursor attributes of pl/sql.

1051

How to create an array in pl/sql?

1073

What is ttitle and btitle?

1066

what are the performance and scalability characteristics of mysql? : Sql dba

999

Can I learn sql in a week?

1082

How to rename a column in the output of sql query?

1072

Is there any restriction on the use of union in embedded sql?

1160

Which sql statement is used to delete data from a database?

964

Can we join two tables without common column?

1011

Can you have more than one key in a database?

938

What is a null value?

1150

How do I filter in sql profiler?

999