Answer Posted / bunty

IN - used to select multiple rows based on any of the key
provided

SQL - select distinct employeeid from orders where orderid
in ( select orderid from orderdetails where discount >= 10)


ANY - used in case of relational queries to compare result
with any of the key.

SQL - select custID from orders where regionID != "E" and
discount > any (select discount from orders where regionID
= "E" and discount > 3)

ALL - used in case of relational queries to compare result
with all of the keys.

SQL - select custID from orders where regionID != "E" and
discount > all (select discount from orders where regionID
= "E" and discount > 3)

Cheers -
Bunty

What is a join?

1046

---

Which is better cte or subquery?

1015

---

Write a sql query to get the third highest salary of an employee from employee_table?

1057

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7272

---

What is exit statement?

1000

---

Which is faster truncate or drop?

1030

---

Is clustered index a primary key?

932

---

Is t sql a programming language?

1049

---

How many parts of a pl sql block are optional?

1101

---

What are some emotional triggers?

964

---

What is pivot query?

1056

---

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

1007

---

how can we destroy the session, how can we unset the variable of a session? : Sql dba

981

---

Is merge a dml statement?

953

---

What are different types of keys?

1084

---