How to read 2nd highest sal from EMP table?
Answers were Sorted based on User's Feedback
Answer / sasikala
select max(salary) from emp where salary<(select max(salary) from emp);
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / b.kumar
-- USING MS SQL SERVER
SELECT TOP 1 FROM
( SELECT DISTINCT TOP 2 FROM EMP ORDER BY SAL DESC) EMP
ORDER BY SAL ASC
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gali kondareddy
SELECT * FROM EMP WHERE SAL =(SELECT MIN(SAL) FROM EMP WHERE SAL IN (SELECT TOP 2 SAL FROM EMP ORDER BY SAL DESC))
Is This Answer Correct ? | 1 Yes | 0 No |
SELECT MAX(EMP_SALARY) FROM EMP
WHERE EMP_SALARY NOT IN (SELECT MAX(EMP_SALARY) FROM EMP)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / arnab bhui
Using Oracle........
create table emp
( id number(10),
sal numeric(10,5)
);
SQL> select max(sal) from (( select sal from emp ) minus ( select sal from emp where sal >= all ( select sal from emp )));
Is This Answer Correct ? | 1 Yes | 2 No |
how to rest identity columns in sql server
how many non clustered index in sql server 2008,2010,2012
How do I setup a sql server database?
select empid empname from employee What is the result for the about query?
What are the different types of subquery?
List the different index configurations possible for a table?
What is the difference between char and varchar2 datatype in sql?
If user is owning any SQL Objects, can we drop that user
Explain about protocol layer present in SQL server?
Explain steps of normalization?
What are the different types of replication you can set up in sql server?
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?