how to find nth highest salary

Answer Posted / haribabuboddapati

select max(sal)*from emp
where sal>select max(sal)*from emp

Is This Answer Correct ?    24 Yes 100 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dirty page?

566


Explain the dirty pages?

575


What is collation?

715


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1053


Explain tables in SQL Azure?

96






Issues related in upgrading SQL Server 2000 to 2005 / 2008

1501


Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

521


You want to implement the one-to-many relationship while designing tables. How would you do it?

503


What is "scheduled jobs" or "scheduled tasks"?

554


Is natural join and equi join same?

526


How to round a numeric value to a specific precision?

571


You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

547


How do I know if localdb is running?

509


What encryption security is available in sql azure?

81


What is the difference between web edition and business edition?

89