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
How do temporal tables work?
What is sqlcommand?
What is sql resultset?
How many row comparison operators are used while working with a subquery?
How do I copy a table in sql?
What is scalar function in sql?
What is pl sql architecture?
What is java sql drivermanager?
How do I send sql query results to excel?
What is sql in java?
Can a composite key be null?
What is normalization sql?
what is online transaction processing (oltp)? : Sql dba
What is a behavioral trigger?
What is a primary key sql?
