Interested to Buy Any Domain ? << Click Here >> for more details...
find 2nd highest salary of person using cursor concept?
- 6 Answers
- 11921 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / b.mamatha
select * from tabl1 where salary=(select max(salary) from
tabl1 where salary<(select max(salary) from tabl1)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
What is enhanced database mirroring in sql server 2008?
How do I manually uninstall an instance of sql server 2016?
Do you know nested transaction?
What are different types of subquery?
What is the importance of a recovery model?
What is the recursive stored procedure in sql server?
What is the difference between a function and a stored procedure?
What are the main differences between #temp tables and @table variables and which one is preferred?
What is SQL Server?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
Explain nested join?
How many partitions a clustered index has by default in sql server 2012?
How to connect to a sql server using odbc_connect()?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
