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
What is dirty page?
Explain the dirty pages?
What is collation?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
Explain tables in SQL Azure?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
You want to implement the one-to-many relationship while designing tables. How would you do it?
What is "scheduled jobs" or "scheduled tasks"?
Is natural join and equi join same?
How to round a numeric value to a specific precision?
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?
How do I know if localdb is running?
What encryption security is available in sql azure?
What is the difference between web edition and business edition?