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 are “phantom rows”?

1609

How self join is different from outer join?

1063

What are the commands used in DCL?

969

How to create new tables with "create table" statements in ms sql server?

1001

Why is sql server log file full?

979

What is data source object?

952

what is an extended stored procedure? : Sql server database administration

992

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

982

What is the return type of executeupdate ()?

859

what are the different types of SSRS reports?

146

How to restore performance issues and how to check?

1950

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1000

What is cte (common table expression)?

979

What are the different types of stored procedures?

1069

what is checksum in sql server.........???

1623