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.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Why do we use partitions in sql?
What is application trigger?
What is the use of primary key?
Explain how exception handling is done in advance pl/sql?
Is pl sql a scripting language?
What mean sql?
Explain the components of sql?
Explain what is table in a database?
Who developed sql?
what is error ora-03113: end-of-file on communication channel?
What is on delete set null?
Explain two easy sql optimizations.
What is bind reference and how can it be created?
How to get each name only once from an employee table?
How to write a query to show the details of a student from students table whose
