Answer Posted / vamsi krishna
For 2nd maximum salary
select Max(sal) from EMP a where 2=(select COUNT(distinct(sal)) from EMP b where a.SAL<=b.SAL);
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
What is the difference function and stored procedure?
What is the need for indexing?
What is ms sql server service broker?
Why use triggers?
How to generate random numbers with the rand() function in ms sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What is the maximum size of a row in sql server?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
how many type of indexing in database?
How to drop an existing table with "drop table" statements in ms sql server?
Explain indexed views?
What are the different types of locks in the database?
Explain the truncate command? : SQL Server Architecture
Which are ddl commands?
