can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 24944 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / naufal basheer
select e.* from
(select row_number() over (order by salary desc) as Rno,*
from employee)e
where e.Rno = 2
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
Are connections to sql server encrypted?
What are transactions and its controls?
Write a sql query to delete duplicate records from a table called table1
How to recompile stored procedure at run time?
What are the types of sql server?
What is collation sensitivity?
What is ms sql server index?
In case you have filters in your report, when filters will be applied in cached report instance?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What options are available to audit login activity? : sql server security
Explain why variables called the most powerful component of ssis?
How many triggers you can have on a table?
What are the advantages of using third-party tools?
How to list all user defined functions in the current database?
