Answer Posted / manoj

IN- It will return the value based on the parameter;
e.g. select * from emp where salary in ('1000','3000');

ANY-It will compare with any value that has been returned by
the parameter;

select * from emp where salary > any(select salary from emp
where deptno=10)
the salary will be compared with any value that has been
returned by the subquery.

ALL-It will compare with max/min value that has been
returned by the subquery;

select * from emp where salary > all(select salary from emp
where deptno=10)
the salary will be compared with the longest value that has
been returned by the subquery.

Where can I learn sql for free?

930

---

How to use sql*plus built-in timers?

1092

---

What is nosql db?

923

---

Which join is default?

894

---

How does sql store data?

865

---

How to select all records from the table?

1066

---

what is the difference between a web-garden and a web-farm? : Sql dba

1009

---

how to install mysql? : Sql dba

1041

---

How many aggregate functions are available there in sql?

926

---

Is sqlite free?

907

---

How do I find duplicates in the same column?

996

---

What is trigger in sql and its types?

987

---

Is json a nosql?

914

---

What is the basic form of sql query?

879

---

What is cursor explain with example?

921

---