can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 34160 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / arun ashok
Select max(salary) from employee where salary not in (select
max(salary) from employee)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is temporary table in sql server? Why we use temp table?
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
Can we shrink data file in sql server?
What is the difference between upgrade and migration in sql server?
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?
what is the difference between openrowset and openquery?
Why should you use or avoid select * statements?
What is sql server query analyzer?
How can I check that whether automatic statistic update is enabled or not?
What is sql or structured query language?
How to provide default values to function parameters?
What is a scheduled job or what is a scheduled task?
Where can you add custom error messages to sql server?
How can we solve concurrency problems?
How to remove duplicate rows from table except one?
