Answer Posted / elumalai d

--QUESTION36:-What is different between union and minus?

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;

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;

DROP TABLE question36;
DROP TABLE quest36;

What is partition in sql query?

950

---

what is the functionality of the function htmlentities? : Sql dba

894

---

what are the differences between binary and varbinary? : Sql dba

978

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

901

---

Explain the order of sql statement execution?

980

---

How do I get sql certification?

926

---

What are the methods of filing?

878

---

Which are the different case manipulation functions in sql?

955

---

What is set serveroutput on in pl sql?

1200

---

What is the difference between nvl function, ifnull function, and isnull function?

1052

---

What does over partition by mean in sql?

923

---

What is a procedure in pl sql?

1131

---

What is database sql?

988

---

Where is pl sql used?

906

---

What is the most common sql injection tool?

997

---