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 |
what is checksum in sql server.........???
How do I find the query plan in sql server?
How can I create a plain-text flat file from SQL Server as input to another application?
How do you create a data source?
Explain about analysis services?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
Give me any three differences between Truncate and Delete.
What is row_number function?
What is side by side migration in sql server?
What is a transact-sql statement batch in ms sql server?
What are the benefits and tasks of object explorer? : sql server management studio
Explain about temporary stored procedure?