find 2nd highest salary of person using cursor concept?
- 6 Answers
- 9834 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / krish
select max(sal) frem tbl where sal <(select max(sal) from tbl;
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What factors you will consider calculating the storage requirement for that view?
Tell me about the approaches which you used to counter the DI problems.
What is table value parameters (tvp)?
What is difference between index and primary key?
What does the update command do?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What samples and sample databases are provided by microsoft?
Name three of the features managed by the surface area configuration tool? : sql server security
How to download and install microsoft sql server management studio express?
What do you mean by sql server agent?
What is oltp (online transaction processing)?
What do you understand by replication in sql server?
How do I uninstall sql server 2014?
What is the difference between mysql and sql server?
What does this statement do @@rowcount?
