select max(salary) from emp where salary<(select max(salary) from emp);

How to read 2nd highest sal from EMP table?

Question Posted / sasikala

Answer Posted / sasikala

Is This Answer Correct ?

11 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain what are sparse columns?

1066

Define model database?

1032

What do you mean by 'normalization'?

1121

Which Model uses the SET concept

1042

What are the Advantages of using CTE in sql server?

1166

What is table constraint?

1052

Tell me what are the essential components of sql server service broker?

986

How to perform key word search in tables?

1001

Do you know what is a linked server in sql server?

1068

What is a select query statement in ms sql server?

1129

Explain what are partitioned views and distributed partitioned views?

1014

What happens if null values are involved in comparison operations?

1042

Can an entity have two primary keys?

1030

Can I delete event logs?

977

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1133