how to find nth highest salary
Answer Posted / chandra sekhar
select min(salary) from emp where salary in (select top n salary from emp order by salary desc)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Where is localdb stored?
What is difference between createstatement and preparedstatement?
What are different type of Collation Sensitivity?
What is the data type of time?
What is row-level compre?
What is the process of normalization?
What is the difference between clustered index and primary key?
Is resultset an interface?
What factors you will consider calculating the storage requirement for that view?
What is difference between aggregate and analytic function?
Please illustrate physical database architecture? : SQL Server Architecture
Differentiate between truncate vs delete in mssql?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
Can you name some of the dml commands in sql?
Can you index views?