Answer Posted / tanu

UNION: Union Combines results of all select statements,
displaying duplicate rows only one time in the answerset.

Rules for usage:
1. All select clauses must have same number of expressions.
2. Corresponding expressions must have compatible domains.

First SELECT statement:
->Determines output format.
->Determines output title.

Last SELECT statement:
->Contains ORDER BY for the entire result, if required.

EXAMPLE:
SELECT first_name
,last_name
,'employee' (TITLE 'employee//type')
FROM employee
WHERE manager_employee_number = 1019
UNION
SELECT first_name
,last_name
,' manager '
FROM employee
WHERE employee_number = 1019
ORDER BY 2
;

RESULT:

first_name last_name employee_type
Carol Kanieski employee
Ron Kubic manager
John Stein employee

JOIN:
Join is a technique for accessing data from more than one
table in a single answerset. Each row in the answerset may
contain data from columns of more than one table. Tables
are joined on columns sharing common domain.

Can I create table without primary key?

997

---

What is a dirty read sql?

1134

---

What information is needed to connect sql*plus an oracle server?

1026

---

What is materialized view in sql?

918

---

Name the operator which is used in the query for pattern matching?

945

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

999

---

What is difference between inner join and self join?

1084

---

How do I write a sql query in pgadmin 4?

974

---

What is dense_rank?

933

---

Can I call a procedure inside a function?

1011

---

How to load data with sql*loader?

1046

---

What is scalar function in sql?

1038

---

What is thread join () in threading?

1008

---

What are the possible values that can be stored in a boolean data field?

998

---

Is sql free?

956

---