Answer Posted / rahul gaikwad

Let's consider the difference between Minus and Union using
following examples.

1.create TABLE A AND B With similar structure
2.insert records in Table A and B.
3.Keep some records identical(here 2 rows).
4.find out the difference betwn 2 looking into the output.


CREATE TABLE A(NAME VARCHAR2(30));
INSERT INTO A VALUES('A');
INSERT INTO A VALUES('B');
INSERT INTO A VALUES('C');
INSERT INTO A VALUES('D');
COMMIT;

CREATE TABLE B(NAME VARCHAR2(30));
INSERT INTO b VALUES('A')
INSERT INTO b VALUES('B')
INSERT INTO b VALUES('Y')
INSERT INTO b VALUES('X')
COMMIT;



1) SELECT * FROM A
MINUS
SELECT * FROM B

NAME
------------------------------
C
D
2 rows selected



2)SELECT * FROM A
UNION
SELECT * FROM B


NAME
------------------------------
A
B
C
D
Y
x
6 rows selected

What is the use of sqlerrd 3?

993

---

How to run sql statements through the web interface?

1092

---

How can I speed up sql query?

1007

---

Why coalesce is used in sql?

1067

---

Explain what is sql?

1180

---

How many types of sql are there?

1045

---

Does sql require a server?

1055

---

Can we rename a column in the output of sql query?

1039

---

Can we use joins in subquery?

1224

---

Explain correlated query work?

1101

---

What is a constraint? Tell me about its various levels.

1246

---

how to increment dates by 1 in mysql? : Sql dba

1031

---

Which is faster subquery or join?

1269

---

What is the max nvarchar size?

1028

---

What are the types of operators available in sql?

1125

---