SELECT e.lastname,e.salary FROM employees e WHERE 1=(SELECT count(*) F

How to find 1st, 2nd, 3rd highest using select select
statement not using rownum

Question Posted / annada

Answer Posted / annada

SELECT e.lastname,e.salary FROM employees e
WHERE 1=(SELECT count(*) FROM employess s
WHERE s.salary>e.salary

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to handle a single quote in oracle sql?

1058

What is the purpose of save points in oracle database?

1124

defination of bitmap index

2132

Is primary key indexed by default in oracle?

992

What privilege is needed for a user to create views in oracle?

1055

Explain the use of analyse option in exp command.

1131

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1865

Why is oracle database so popular?

1012

How to open and close an explicit cursor in oracle?

1058

Can you tell me how to add new column in existing views?how?How is possible?

1451

How do we get field details of a table?

982

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2209

How to fetch the row which has the max value for a column?

1002

How to connect to a remote server?

1130

What is SQL Tuning Advisor in Oracle?

1185