find 2nd highest salary of person using cursor concept?
Answer Posted / amruta dash
select max(salary) from tbl where salary not in (select max
(salary) from tbl);
Is This Answer Correct ? | 11 Yes | 6 No |
Post New Answer View All Answers
How do I start sql server?
What are policy management terms?
Differentiate between SQL and ORACLE joins and write their syntax.
What is the stored procedure?
What will be the maximum number of index per table?
Does index speed up select statements?
How to add code to the existing article (using improve article)?
What are the differences between stored procedure and the dynamic sql?
How does clustered and non clustered index work?
Explain differentiate between a having clause and a where clause?
How to make remote connection in database?
How to define the name and server for a new dsn?
What are the transaction properties?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
Explain how to integrate the ssrs reports in application?