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

Tell me what are the essential components of sql server service broker?

928

How to create a simple user defined function in ms sql server?

999

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1080

List out what other servers you can use with ssrs?

137

How to insert data with null values?

1006

How do you delete a data source?

991

What is the optimization being performed in oracle and SQL Server?

1030

How to include text values in sql statements?

1020

What is the benefit of normalization?

1061

What are .mdf files?

922

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1031

Do you know what are acid properties?

1052

How check triggers in sql server?

966

How many databases can we create in a single server?

207

How adventureworkslt tables are related?

912