Select max(sal) from emp where id='1233' and Sal< (select max

can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Question Posted / mahesh

Answer Posted / mahesh

Select max(sal) from emp
where id='1233' and Sal< (select max(sal) from emp)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the advantages of stored procedure in sql server?

930

What is the impact on other user sessions when creating indexes?

963

Why is normalisation important?

989

Differentiate between mongodb vs. Sql server?

1140

Explain Geography datatype in SQL Server

1190

What is SQL Azure Firewall?

136

List down some advantages of sql stored procedure?

1014

Explain can you implement data mining in ssrs?

161

Explain the steps needed to create a scheduled job?

977

Explain the concepts and capabilities of sql server?

1011

What is the datatype of rowid?

963

How to find the service pack installed? : sql server database administration

1062

What is optimization and its types?

1037

Write down the syntax and an example for create, rename and delete index?

1024

What is database white box testing?

1176