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

28 Answers
32723 Views
IBM, Symphony, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is an index. What are the types?

1093

What are the differences between web role and worker role?

122

What is row_number () and partition by in sql server?

1087

What is the use of commit?

1004

What are the kinds of subquery?

1010

Can we add our custom code in ssis?

994

Explain can you implement data mining in ssrs?

161

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1150

What is 3nf normalization?

1004

List all types of constraints in sql server?

1050

Why the trigger fires multiple times in single login?

1216

What is a data source or ds? : sql server analysis services, ssas

1011

How to execute a stored procedure in ms sql server?

1186

What are the components of sql server service broker?

1021

What is difference between stored procedure and user defined function?

1116