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

how to find nth highest salary

Question Posted / haribabuboddapati

Answer Posted / haribabuboddapati

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

Is This Answer Correct ?

24 Yes

100 No

Please Help Members By Posting Answers For Below Questions

What happens when converting big values to numeric data types?

1032

Explain about merge replications?

967

What is service broker? : sql server database administration

942

What is SubQuery in SQL Server 2008

966

How dts is used to extract, transform and consolidate data?

1025

What is difference between equi join and inner join?

860

how to determine the service pack currently installed on sql server? : Sql server database administration

909

How many servers can we create in a single subscription?

158

How to rename databases in ms sql server?

1128

Data table as parameter in sql server?

976

What function does a database engine serve in the sql server?

988

What is cdc in sql server?

953

Where are SQL server users names and passwords are stored in sql server?

1200

What is @@rowcount in sql?

952

whats new about truncate in sql server 2008?

2442