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 happens when converting big values to numeric data types?
Explain about merge replications?
What is service broker? : sql server database administration
What is SubQuery in SQL Server 2008
How dts is used to extract, transform and consolidate data?
What is difference between equi join and inner join?
how to determine the service pack currently installed on sql server? : Sql server database administration
How many servers can we create in a single subscription?
How to rename databases in ms sql server?
Data table as parameter in sql server?
What function does a database engine serve in the sql server?
What is cdc in sql server?
Where are SQL server users names and passwords are stored in sql server?
What is @@rowcount in sql?
whats new about truncate in sql server 2008?