Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 31717 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / kumar amit ranjan
To find Top 3 max Sal.... to put any number on the place of
3 to find nth max sal...
select top 3 sal from emp order by sal desc
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to find related tables in sql server?
what method you can use to reduce the overhead of Reporting Services data sources?
What is the cpu pressure?
What will be the maximum number of indexes per table?
What is the difference between createstatement and preparedstatement?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
How do you delete a data source?
What is row_number () and partition by in sql server?
What is an execution plan?
What do you mean by the term 'normalization'?
What the different topologies in which replication can be configured?
Name three of the features managed by the surface area configuration tool? : sql server security
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What triggers long term care?
How to use subqueries with the in operators in ms sql server?
