select * from (select sal from table1 group by sal ) where row num=3

find the third highest salary?

Question Posted / anil pednekar

Answer Posted / anil pednekar

select * from (select sal from table1 group by sal ) where
row num=3

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is a primary key sql?

1042

What is clause in sql?

1108

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1438

How to use sql*plus built-in timers?

1200

what are the disadvantages of mysql? : Sql dba

1149

How many types of triggers exist in pl/sql?

1072

What is the difference between sql and mysql?

1117

How do I run a pl sql program?

1128

What is a temporal data type?

1052

how can we know the number of days between two given dates using mysql? : Sql dba

1048

When should I use nosql database?

1007

What is sql clause?

1049

What is the difference between inner join and left join?

989

Write the alter statement to enable all the triggers on the t.students table.

1125

Is foreign key mandatory?

1003