Interested to Buy Any Domain ? << Click Here >> for more details...
find 2nd highest salary of person using cursor concept?
- 6 Answers
- 12106 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
Explain trigger classes i.e. Instead of and after trigger?
Explain system scalar functions?
Please explain go command in sql server?
What is a coalesce function?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What according to you is the difference between mysql and sql server performance?
What are the differences between local and global temporary tables?
Explain iaas, paas and saas?
What is difference between count (*) and count 1?
Why we use functions in sql server?
Explain what is the main purpose of having conversation group?
Tell me extended events in sql server 2008?
Tell me what are the essential components of sql server service broker?
Write a SQL query to delete a table?
What are the triggers in sql?
