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

Define Wed Edition in SQL Azure?

100

What is the maximum row of a size?

957

Explain table valued parameters in sql server? Why tvp used?

967

What to perform pattern match with the like operator?

842

Tell me what is de-normalization and what are some of the examples of it?

959

What are the main differences between #temp tables and @table variables and which one is preferred?

1015

How to rebuild indexes with alter index ... Rebuild?

1035

How to get the definition of a view out of the sql server?

942

Can sql servers link to other servers like oracle?

795

How to apply cascading referential integrity in place of triggers?

971

What is sql language?

1030

How to perform key word search in tables?

914

Is there any difference between primary key and unique with the not null condition?

888

Explain the different types of backups available in sql server? : sql server database administration

865

What is bcp? When does it use?

874