select max(sal) from t1 where sal not in (27777); 27777 is max salary in

how to find the second salary?

Question Posted / m.s.patil

Answer Posted / m.s.patil

select max(sal) from t1 where sal not in (27777);

27777 is max salary in table

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a View ? Can we insert, Update and delete a view?

1064

What is factless fact table? : sql server analysis services, ssas

1098

What are the benefits and tasks of object explorer? : sql server management studio

1258

How to list all objects in a given schema?

1109

What is the web service used for reporting services?

126

Ways to improve the performance of a SQL Azure Database?

125

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1112

What is serializable?

1090

How to create a new login name in ms sql server?

1109

What do you do in data exploration

1050

How to insert multiple rows with one insert statement in ms sql server?

1181

How to delete multiple rows with one delete statement in ms sql server?

1075

What are triggers in ms sql server?

1230

Explain subquery and state its properties?

1094

What is the cartesian product of the table?

1007