how to find the second highest salary from emp table?
Answers were Sorted based on User's Feedback
Answer / gaurav singh 'viccky'
select salary from user=(select max(salary)from user where
salary < (select max(salary)from user))
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / arjunraj
aa means table-alias name
bb means table-alisa name
select * from emp aa where 2=(select count(distinct empsalary) from emp bb where aa.empsalary<=bb.empsalary)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / dakshin
select * from (select a.*,dense_rank() over (order by sal) rnk from emp a order by sal) where rnk =2
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kishor dange
select max(sal) from table_name where sal<(select max(sal)
from table_name)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vikas
select top 1 salary from emp
where salary in (select top 2 salary from emp order by salary desc)order by salary
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ashwini
select max(salary) from employee where salary < (select max(salary) from employee)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / manjusha
select * from emp e1
where 2=(select count(distinct salary) from emp e2
where e1.sal<e2.sal);
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / hari thorat
select max(salary) from employee where salary <(select max(salary) from employee);
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gunjal ghagre
Select sal from table_name order by sal desc limit 1,1;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / debasish
select ename,sal from (select ename,sal,row_number()
over(order by sal desc)rn from emp)
where rn=1;
Is This Answer Correct ? | 0 Yes | 0 No |
How do I run a sql query in pgadmin 4?
what are enums used for in mysql? : Sql dba
What are the two virtual tables available at the time of database trigger execution?
Types of joins ?
What is trigger and how to use it in sql?
What is sqlcontext?
Explain what is dbms?
Does a join table need a primary key?
what is log shipping? : Sql dba
How do you respond to dementia behavior?
What is a schema in sql?
What is the use of cursor ? how cursor allocate context area for executing the sql statement?