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
- 7844 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 primary key in db?
Can a table contain multiple foreign key’s?
What does inner join mean?
What are the disadvantages of file system?
Where is all the data on the internet stored?
What mean sql?
Is mariadb a nosql database?
How do rank () and dense_rank () differ?
What is data control language?
What is audit logout in sql profiler?
what are the authentication modes in sql server? : Sql dba
what are the different type of normalization? : Sql dba
What is implicit cursor in pl sql?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What are the types of functions in sql?
