Answer Posted / mohamed shahid(broadline)

IN:-EQUAL TO ANY MEMBER
EX:-
---
SELECT ENAME,SAL,DEPTNO FROM EMP WHERE SAL IN(SELECT MIN(SAL) FROM EMP GROUP BY DEPTNO);

ANY(<):-COMPARES VALUE TO EACH VALUE RETURNED BY THE SUBQUERY
EX:-
SELECT EMPNO,ENAME,JOB FROM EMP WHERE SAL<ANY(SELECT SAL FROM EMP WHERE JOB='CLAERK');

NOTE:-IT MEANS LESS THAN MINIMUNM VALUE.
ANY(>):-
------

SELECT EMPNO,ENAME,JOB FROM EMP WHERE SAL>ANY(SELECT SAL FROM EMP WHERE JOB='CLERK');

NOTE:-
-----
>ANY:-IT MEANS MORE THAN MINIMUM
=ANY:- IT IS EQUIVALENT TO IN OPERATOR

ALL:-COMPARES VALUE TO EVERY VALUE RETURNED BY THE SUBQUERY

SELECT EMPNO,ENAME,JOB FROM EMP WHERE SAL>ALL(SELECT AVG(SAL) FROM EMP GROUP BY DEPTNO);
NOTE:-
---
>ALL IT MEANS MORE TAHN MAXIMUM


SELECT EMPNO,ENAME,JOB FROM EMP WHERE SAL<ALL(SELECT AVG(SAL) FROM EMP GROUP BY DEPTNO);
NOTE:-
---
ALL<:-IT MEANS LESS THAN MINIMUM

Sql technical questions

777

---

Is sql port 1433 encrypted?

576

---

what is subquery? : Sql dba

569

---

What is the difference between instead of trigger and after trigger?

514

---

How to take user input in pl sql?

705

---

---

What is oracle sql developer?

605

---

Can you skip header records while loading? : aql loader

544

---

How to run sql statements with oracle sql developer?

625

---

How do you know if a relationship is 2nf?

520

---

How many row comparison operators are used while working with a subquery?

537

---

What is meaning of <> in sql?

587

---

Explain ttitle and btitle.

671

---

What are data types in pl sql?

564

---

What is normalization? How many normalization forms are there?

554

---

How do I find duplicates in a single column in sql?

536

---