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

How do I edit a stored procedure?

945

Is ms sql traffic encrypted?

867

How many disk partitions should I have?

936

How many triggers can be applied on a table?

875

How do I run sql?

1092

Why partition by is used in sql?

963

How to use sql statements in pl/sql?

1050

What are variables in pl sql?

1090

What is the limitation on the block size of pl/sql?

935

What is coalesce in sql?

970

How do I run pl sql in sql developer?

1056

what is innodb? : Sql dba

1029

What is difference between rank () row_number () and dense_rank () in sql?

1046

how to show all tables with 'mysql'? : Sql dba

1058

Explain architecture of sql server notification services?

981