Suresh, you are exactly correct

what is the difference between union and union all

Question Posted / a.jyothsna

Answer Posted / a.jyothsna

Suresh,
you are exactly correct

Is This Answer Correct ?

53 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What is the difference between subquery and correlated query?

1117

How to display the records between two range in Oracle SQL Plus?

1196

what is the bond code in materialized view?

3060

Is pl sql different from sql?

1043

Why we use triggers in mysql?

1038

What is sql used for?

1165

What are all ddl commands?

1129

Can we insert data into view?

950

Explian rowid, rownum? What are the psoducolumns we have?

1045

How do I remove all records from a table?

1117

What are predefined functions in sql?

1108

How do I copy a table in sql?

1037

Can a primary key be a foreign key?

1080

What are the various levels of constraints?

1168

What are its different types of dbms?

1055