this is for 2nd highest sal in sql server database select * from emp whe

find out the second highest salary?

Question Posted / ananth

Answer Posted / ananth

this is for 2nd highest sal in sql server database

select * from emp where sal=(select max(sal) from emp where
sal<(select max(sal) from emp))

Is This Answer Correct ?

119 Yes

13 No

Please Help Members By Posting Answers For Below Questions

defination of bitmap index

2178

What is merge in oracle?

1096

State any two functions of oracle?

1097

What is an oracle cursor variable?

1133

How do I connect to oracle?

1080

How to get last row id?

1054

Explain the different normalization forms?

1157

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4571

What is transaction control statement and how many types of transaction control statement in Oracle?

1235

How to start a new transaction in oracle?

1136

How would you change old and new values in an insert, delete and update triggers?

1077

Why packages are used in oracle?

1118

what is the difference between data migration and production migration.

2398

How will you identify oracle database software release?

1058

What is the difference between truncate & delete command?

1236