select * from emp where sal in(select max(sal) from emp)
here there is any limit for in operator how many values
accpect ?
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 the basic structure of an sql?
How can I see all tables in sql?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What does where 1/2 mean in sql?
what are date and time functions in mysql? : Sql dba
Define concurrency control. : Transact sql
What is normalisation and its types?
Why is sql important?
What is a crud api?
Explain the steps needed to create the scheduled job?
What is dialect in sql?
How run sql*plus commands that are stored in a local file?
What is the full form of sql?
Is trigger a stored procedure?
Can we use ddl statements in stored procedure?