Answer Posted / elumalai d

UNOIN:- It returns all the records from both tables without duplicates.
Example:-
A={1,2,3,4}
B={2,3,4,5,6}
AUB={1,2,3,4,5,6}

CREATE TABLE question36 (empid NUMBER);
CREATE TABLE quest36 (empid NUMBER);

INSERT INTO question36 VALUES(1);
INSERT INTO question36 VALUES(2);
INSERT INTO question36 VALUES(3);
INSERT INTO question36 VALUES(4);

INSERT INTO quest36 VALUES(2);
INSERT INTO quest36 VALUES(3);
INSERT INTO quest36 VALUES(4);
INSERT INTO quest36 VALUES(5);
INSERT INTO quest36 VALUES(6);
COMMIT;

SELECT empid FROM question36
UNION
SELECT empid FROM quest36;

EMPID
---------
1
2
3
4
5
6

DELETE FROM question36;
DELETE FROM quest36;
COMMIT;

MINUS:- It returns table A values not available in table B.
Example:-
A={1,2,3,4}
B= {2,3,5}
A-B={1,4}

INSERT INTO question36 VALUES(1);
INSERT INTO question36 VALUES(2);
INSERT INTO question36 VALUES(3);
INSERT INTO question36 VALUES(4);

INSERT INTO quest36 VALUES(2);
INSERT INTO quest36 VALUES(3);
INSERT INTO quest36 VALUES(5);
COMMIT;

SELECT empid FROM question36
MINUS
SELECT empid FROM quest36;

EMPID
---------
1
4

DROP TABLE question36;
DROP TABLE quest36;

How can I change database name in sql?

1157

---

How to rename a table?

1075

---

Which query operators in sql is used for pattern matching?

1011

---

Why truncate is faster than delete?

1161

---

Explain locks? : Transact sql

1055

---

how many ways we can we find the current date using mysql? : Sql dba

1145

---

Is nosql relational?

1000

---

What are few of the schema objects that are created using PL/SQL?

1082

---

Differentiate between syntax and runtime errors.

1242

---

Is left join faster than inner join?

1169

---

What is benefit of creating memory optimized table?

1033

---

what are date and time functions in mysql? : Sql dba

1025

---

What is the difference between function, procedure and package in pl/sql?

1354

---

What is the execution plan in sql?

1070

---

How do you pronounce sql?

1059

---