select salary from emp order by salary desc limit 0,1;

find out the second highest salary?

Question Posted / tejinder

55 Answers
87734 Views
Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
E-Mail Answers

Answer Posted / tejinder

select salary from emp order by salary desc limit 0,1;

Is This Answer Correct ?

0 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a schema in oracle?

968

How to create an oracle database manually?

1023

What is the difference between online and offline backups?

973

What is the difference between sharding and partitioning?

931

What are the advantages of oracle?

963

What is instant client oracle?

973

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5333

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1795

What is an oracle data file?

1039

Explain coalesce function?

1119

What are the different types of record groups in oracle? Explain each of them

972

What is the difference between substr & instr functions?

1123

What is the sql query to concatenate column values from multiple rows in oracle?

999

What are transaction isolation levels supported by oracle?

996

How do you tell what your machine name is and what is its IP address?

2006