Interested to Buy Any Domain ? << Click Here >> for more details...
select * from emp where sal in(select max(sal) from emp)
here there is any limit for in operator how many values
accpect ?
- 2 Answers
- 7747 Views
- I also Faced
- E-Mail Answers
Answer Posted / venkat
hi
let us suppose we have 5 employees in emp table having sal
2000,3000,2300,4500,3400
subquery- select max(sal) from emp picks only one value i.e
max-4500
there is no limit for IN Operator.see the below example
subquery- select sal from emp where sal/100=0;
if u hav n number of sal's are divisible by 100 the IN
operator must work on all the SAL's divisible by 100.
According to the usage we need to use best query to retrieve
data by keeping min work on server
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is scalar and vector?
Define implicit and explicit cursors.
What is number function in sql?
What are the possible values that can be stored in a boolean data field?
What is embedded sql what are its advantages?
What is primary key and unique key?
Why are aggregate functions called so?
What do you know by pl/sql cursors?
How much ram can sql express use?
What is lookup table in sql?
Explain the steps needed to create the scheduled job?
What packages(if any) has oracle provided for use by developers?
What is a file delimiter?
Are null values same as that of zero or a blank space?
What is the purpose of primary key?
