find 2nd highest salary of person using cursor concept?
Answer Posted / b.mamatha
select * from tabl1 where salary=(select max(salary) from
tabl1 where salary<(select max(salary) from tabl1)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What stored by the master? : sql server database administration
How to declare a cursor with "declare ... Cursor" in ms sql server?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What is the difference between a stored procedure and a user defined function?
List the ways in which dynamic sql can be executed?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What are ddl triggers and types of ddl trigger?
Difference between primary key and clustered index?
Explain different types of locks in sql server.
Is there any difference between the primary key and unique key?
Explain the Ways to improve the performance of a sql azure database?
How to search for a string in all stored procedure in sql server?
Explain what are the authentication modes in sql server?
What are the types of sql server?
List the types of recovery model available in sql server?