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 I remove sql plus from windows 10?
how tsql statements can be written and submitted to the database engine? : Transact sql
What is the difference between sum and count in sql?
What is a variable in sql?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What are the features of pl sql?
What is cursor and its types?
What are the types of index in sql?
What is the difference between partitioning and sharding?
What is pl sql and why it is used for?
What is difference between primary and secondary key?
How do you optimize a stored procedure in sql?
What is multiple columns?
what is the difference between join and union? : Sql dba
How do you create a unique index?
