SELECT TOP 1 salary FROM( SELECT DISTINCT TOP 3 salary FROM employee OR

find out the third highest salary?

Question Posted / mohd. rashid

Answer Posted / mohd. rashid

SELECT TOP 1 salary
FROM(
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What privilege is needed for a user to query tables in another schema?

1028

What is the relation of a user account and a schema?

1173

How to export your connection information to a file?

1171

What are the differences between char and nchar in oracle?

1140

Explain the dml?

1041

What are the differences between number and binary_float in oracle?

1147

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2336

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2544

What is the usage of save points in oracle database?

1011

Explain the use of record length option in exp command.

1117

What is the difference between Delete, Truncate and Drop in Oracle?

1180

What is the difference between substr & instr functions?

1292

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1975

How to rollback the current transaction in oracle?

1101

What is ceil and floor in oracle?

1118