SELECT SAL FROM EMP E WHERE &N-1 =(SELECT COUNT(*) FROM EMP WHERE E.S

find out the third highest salary?

Question Posted / esha gautam

Answer Posted / esha gautam

SELECT SAL FROM EMP E WHERE &N-1 =(SELECT COUNT(*) FROM EMP
WHERE E.SAL<SAL);

HERE N FOR NTH SALARY!!!!!!!!!!!!!!!!!!!!

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2209

How to export data with a field delimiter?

1039

How to create a temporary table in oracle?

1267

Explain the difference between replace() and translate() functions in oracle?

1036

How to define default values for formal parameters?

1044

Is oracle a relational database?

916

What is the purpose of save points in oracle database?

1118

When do I need to use a semicolon vs a slash in oracle sql?

1090

Why does Oracle not permit the use of PCTUSED with indexes?

2424

How different is ms access and oracle?

1038

How many data types are supported?

1079

What is a relational database management system?

1120

What do you understand by database schema and what does it hold?

1230

What is instant client oracle?

1021

how do u setup a replication site?

1985