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
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 |
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 |
What is the difference between left join and left outer join?
write the Sql query for creating database backup?
What is the difference between python and sql?
What is execution plan in sql?
How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)
Is sql better than excel?
What does where 1 1 mean in sql?
What is an emotional trigger?
what is the use of double ampersand (&&) in sql queries?
Explain cursor types?
What is the difference between distinct and unique in sql?
Explain the types of joins in sql?