select n,* from(select rownum n,* from (select * from table where group b

how to find the second salary?

Question Posted / moorthy t

Answer Posted / moorthy t

select n,* from(select rownum n,* from (select * from table
where group by (sal) order by (sal) desc)) where n=2;

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to sort the query output with order by clauses in ms sql server?

984

What is the synonym of join?

896

How to get @@error and @@rowcount at the same time?

985

What's new in sql management studio for sql server? : sql server management studio

997

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1010

What are trace flags?

963

What is encryption key?

117

What are the limitations/drawbacks or ssrs 2008 r2?

129

Determine when to use stored procedure to complete sql server tasks?

988

What do you mean by the term 'normalization'?

1128

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1015

When would you use sql joins?

913

What is compound operators?

978

What is a synonym for manipulation?

934

What is subquery explain with example?

1009