Interested to Buy Any Domain ? << Click Here >> for more details...
find 2nd highest salary of person using cursor concept?
- 6 Answers
- 11631 Views
- HCL, I also Faced
- E-Mail Answers
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 to make a remote connection in a database?
Name some of the open source software that you can use in alternative to SSR?
How to loop through returning rows?
What is transaction server distributed transaction?
What is the stored procedure?
How do you create a data source?
How do you manipulate data?
How to create a local temporary stored procedure?
What are the disadvantages of using the stored procedures?
Describe the functionalities that views support.
Tell me what do you understand by a view? What does the with check option clause for a view do?
Define primary key?
What is a non clustered primary key?
Can we write trigger for view?
Describe how to use linked server?
