Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 184682 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / yoursguna@gmail.com
SELECT * FROM `salary_table` group by `salary` order by
`salary` desc limit 1,1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
How except clause is differs from not in clause?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
How do you implement session management in SQL Server mode?
What is sql server query analyzer?
How to use user defined functions in expressions?
What is wide table?
What is difference between primary key and foreign key?
What are the types of lock supported by ?
What are the two modes of authentication in sql server?
How to enter unicode character string literals in ms sql server?
What are the types of indexes?
How can sql server instances be hidden?
What are the approximate numeric data types?
