can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answers were Sorted based on User's Feedback
Answer / harikumar
select max(salary) as secondMax from employee where salary
<> (select max(salary) from employee)
Is This Answer Correct ? | 1 Yes | 0 No |
select max(salary)from tablename where salary <(select
max(salary)from tablename)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / darshan shah
select top 1 * from (select top 2 * from emp order by sal
desc ) a order by sal asc
Plz try this.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / govind.konduri
hai..
select sal from emp where sal=(select max(sal) from
emp where sal<(select max(sal) from emp))
->here,the sub inner query finds the max sal from emp table.
->the main inner query find out the max sal that is less
than the sub inner query max sal.
->the sub query result is sent to outer query..
Is This Answer Correct ? | 2 Yes | 1 No |
hi,
my id is ravi106109@gmail.com
select sal from emp a
where 1=(select count(b.sal) from emp b
where a.sal<b.sal) order by sal desc;
and also dileep is write
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / dhaval
we have to use distinct key word there is a possibility
that two person having same salary.
select top 1 sry from (select distinct top 2 sry from emp
order by sry desc)t1 order by sry asc
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / kavitha.r
This query is generalised query if u replace 2 by 100 ,
then you will get 100th max salary
select top 1 salary from employee where salary in( select
top 2 salary from employee order by salary desc) order by
salary asc
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / kumar amit ranjan
To find Top 3 max Sal.... to put any number on the place of
3 to find nth max sal...
select top 3 sal from emp order by sal desc
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / naufal basheer
select e.* from
(select row_number() over (order by salary desc) as Rno,*
from employee)e
where e.Rno = 2
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mahesh
Select max(sal) from emp
where id='1233' and Sal< (select max(sal) from emp)
Is This Answer Correct ? | 1 Yes | 1 No |
There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.
How to get the count of distinct records. Please give me the query?
How to connect a database with sql express.?
How to write character string constants or literals in ms sql server?
What is a sub-query? When would you use one?
What are the differences between left join and inner join in sql server?
Can you insert NULL in unique column?
How to invoke a trigger on demand?
Explain try...catch with sql server?
How you can get the list of largest tables in a database?
Explain the rules for designing files and file groups in sql server?
Explain datetimeoffset data type in sal server 2008?