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 is the Control Flow in SSIS

580

Explain the third normal form(3nf)?

527

Explain what are the restrictions while creating batches in sql server?

596

Is oracle faster than sql server?

559

How to execute a sql statement using odbc_exec()?

576

What is temporal data type?

530

What is collation?

719

What are window functions in sql server?

518

How do I setup a local sql server database?

544

What is sql server used for?

560

What is meant by referential integrity?

596

If any stored procedure is encrypted, then can we see its definition in activity monitor?

559

List the different normalization forms?

548

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

626

Explain user defined views?

583