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

Mention the differences between having and where clause.

1042

How can we use ConnectorJ JDBC Driver with MS SQL?

985

What are the types of resultset?

952

What do you understand by sql server agent?

966

What are cursors in ms sql server?

1155

How to view existing indexes on an given table using sp_help?

1108

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

980

What is indexing in sql server with example?

984

What are relationships and mention different types of relationships in the dbms

947

Please differentiate between a local and a global temporary table?

985

What are two difference between sql azure and azure tables?

159

Explain query editor regions

1030

Explain the disadvantages/limitation of the cursor?

942

what is the difference between Delete and Truncate command in SQL

1128

What are the properties and different types of sub-queries?

991