Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is scope and visibility in PL/SQL?
what is csv? : Sql dba
What are different types of statements supported by sql?
What is information schema in sql?
What is indexes?
Explain the the update statement in sql?
Is sql microsoft?
Where not exists in sql?
What is your daily office routine?
What is self-join and what is the requirement of self-join?
What is an invalid partition table?
What is trigger in flip flop?
What is crud sql?
What is the difference between between and in condition operators?
What is sql partition function?
