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
- 7933 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
How do you update a value in sql?
What are the different schemas objects that can be created using pl/sql?
Can we use ddl commands in pl sql?
What is pragma in sql?
Is sql procedural language?
what tools available for managing mysql server? : Sql dba
What are the three forms of normalization?
What is trigger explain with example?
How many sectors are in a partition?
What is difference between inner join and cross join?
What is difference between primary and secondary key?
Is left join same as inner join?
How to use boolean type in select statement?
What is sql prepared statement?
Write a sql query to get the third highest salary of an employee from employee_table?
