How to read 2nd highest sal from EMP table?
Answer Posted / 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 |
Post New Answer View All Answers
Explain optimistic and pessimistic concurrency?
is there a column to which a default can't be bound? : Sql server database administration
How can we determine what objects a user-defined function depends upon?
how many triggers you can have on a table? : Sql server database administration
Tell me about joins in database system and explain each in detail.
What is a system database and what is a user database?
Explain what are partitioned views and distributed partitioned views?
How to delete a login name in ms sql server?
What is the difference between migration and upgradation in sql server?
What is normalization? What number of normalization shapes are there?
What happens if you are trying to access a schema not owned by you?
Are null values the same as that of zero or a blank space?
What is triggers and stored procedures?
Can truncate be rolled back?
Name three of the features managed by the surface area configuration tool? : sql server security