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 a parameter query?

1039

how to use 'mysql' to run sql statements? : Sql dba

1014

How do you modify a column in sql?

964

What is sql mysql pl sql oracle?

1047

Can we change the table name in sql?

913

What is rownum?

942

what is rollback? : Sql dba

1049

What is difference between mysql and postgresql?

1083

What is the maximum database size for sql express?

985

Define overloaded procedure?

1037

Can we commit in trigger?

942

What is trigger price?

946

explain about mysql and its features. : Sql dba

991

How do I trace sql profiler?

946

what is meant by urlencode and urldocode? : Sql dba

1117