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
- 7809 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
Can we create view in stored procedure?
what are the different type of sql's statements ? : Sql dba
How do I remove all records from a table?
Can pl sql procedure have a return statement?
What is pl/sql language case sensitive?
what is 'mysqlimport'? : Sql dba
how to dump a table to a file with 'mysqldump'? : Sql dba
Will truncate release space?
What is difference between pls_integer and integer?
what are the performance and scalability characteristics of mysql? : Sql dba
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
what is heap table? : Sql dba
how can we destroy the cookie? : Sql dba
What is the difference between pl and sql?
Explain select statements in sql?
