Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 ?

Answers were Sorted based on User's Feedback



select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator ho..

Answer / ashwin

Hi,
if emp table is containing 8 rows and out of which 2 rows
are having highest salary out of 8 rows then 2 rows will be
displayed.

the emp table is given below
sql>select * from emp;

1 1 ram manager 2 1/6/1985 21500.00 2000.00 20
2 2 ankush clerk 2 2/6/1983 30000.00 1000.00 30
3 3 satish sweeper 3 6/12/1987 20000.00 3000.00 30
4 4 clark manager 4 7/15/1967 14000.00 2000.00 40
5 5 richard dba 5 2/9/1995 30000.00 2000.00 50
6 7 monty sweeper 7 1/12/1987 20000.00 3000.00 30
7 8 ganesh sweeper 8 1/12/1988 2000.00 500.00 20
8 9 ganesh manager 9 2/12/1988 20000.00 500.00 30

sql>select * from emp where sal in(select max(sal) from emp;

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
2 ankush clerk 2 2/6/1983 30000.00 1000.00 30
5 richard dba 5 2/9/1995 30000.00 2000.00 50

Is This Answer Correct ?    3 Yes 0 No

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator ho..

Answer / 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

More SQL PLSQL Interview Questions

What is the purpose of normalization?

0 Answers  


Write a procedure to return the month and the number of developers joined in each month (cursor )

2 Answers   Tech Mahindra,


What is the use of sqlerrd 3?

0 Answers  


what is acid property in database? : Sql dba

0 Answers  


What is the difference between the conventional and direct path loads? : aql loader

0 Answers  


what is myisam? : Sql dba

0 Answers  


What is pessimistic concurrency control? : Transact sql

0 Answers  


Why schema is used in sql?

0 Answers  


How do I order by ascending in sql?

0 Answers  


Does sql profiler affect performance?

0 Answers  


what is 'mysqlcheck'? : Sql dba

0 Answers  


What is the location of pre_defined_functions.

0 Answers  


Categories