can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 34124 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
Can we shrink data file in sql server?
How can we solve concurrency problems?
What are the different SQL Server Versions you have worked on?
How to enter binary string literals in ms sql server?
Why should you use or avoid select * statements?
what is the difference between openrowset and openquery?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
do you know how to configure db2 side of the application? : Sql server database administration
Why use identity in sql server?
What is standby servers? Explain types of standby servers.
Explain system functions or built-in functions? What are different types of system functions?
How can I check that whether automatic statistic update is enabled or not?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How do I start sql server 2017?
