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

how to find nth highest salary

Question Posted / haribabuboddapati

103 Answers
182107 Views
Cognizant, IBM, NexGen, Oracle, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1050

What is the stuff?

1009

How do I find the default sql server instance?

946

Can a cursor be updated? If yes, how you can protect which columns are updated?

1114

List down some advantages of sql stored procedure?

969

What is efficiency data?

953

List the different types of joins?

1014

Explain what are commit and rollback in sql?

935

What are different types of replication in sql server?

1093

What are trace files?

966

What is difference between commit and rollback when used in transactions?

966

What is the current limitation of the size of SQL Azure DB?

127

What are the types of table?

980

How to define the name and server for a new dsn?

1123

How to transfer an existing table from one schema to another schema in ms sql server?

982