Interested to Buy Any Domain ? << Click Here >> for more details...
find 2nd highest salary of person using cursor concept?
- 6 Answers
- 11914 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 trouble shoot if unable to connect SQL Server
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Does full backup break log chain?
What is dynamic cursor in SQL SERVER?
How much does sql server 2016 cost?
How do you debug a procedure in sql server?
What are different types of subquery?
What is SQL Azure Federations?
What is sql server replication? : sql server replication
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Can we call future method from trigger?
What are sp_configure commands and set commands?
What is RAID? What are the different types of RAID configurations?
What is merge join?
What are partitioned views and distributed partitioned views?
