Select Top 1 Salary from (Select top 3 Salary from Employee order by sala

Find out the 3rd highest salary?

Question Posted / s.dineshkumar

Answer Posted / s.dineshkumar

Select Top 1 Salary from (Select top 3 Salary from Employee
order by salary desc ) a

Is This Answer Correct ?

0 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is rollback?

1118

What does stand for in sql?

977

Difference between table function and pipelined function?

1028

What is a Mapplet?

1125

What is sql indexing?

1014

Why do we use set serveroutput on?

969

Can we create foreign key without primary key?

987

What is exception? What are the types of exceptions?

1073

how can we repair a mysql table? : Sql dba

983

What is consistency?

1131

Can we insert data into materialized view?

948

What is primary key and foreign key?

963

How does postgresql compare to mysql?

1039

how can you see all indexes defined for a table? : Sql dba

1000

what happens if null values are involved in expressions? : Sql dba

1045