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

find out the second highest salary?

Question Posted / sandeep

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

Answer Posted / sandeep

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

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do we display rows from the table without duplicates?

1019

What is meant by an index?

1224

Explain oracle’s system global area (sga).

1189

What is the oracle implicit cursor?

1113

how to make an oracle object

2396

How to define an external table with a text file?

1128

What do you mean by cdb and pdb in oracle 12c?

1101

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1995

What is tns entry?

1237

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2266

State and explain the different types of data models?

995

What is oracle datasource?

1041

what is port in oracle? how is it related to database application.

1992

What is a directory object?

1137

How to find the duplicate rows count from employees table in oracle?

1148