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 how to convert numeric expression data types using the convert() function??

1030

What is sql server english query?

1100

define and explain the differences between clustered and non-clustered indexes.

1170

Can sql server 2016 run on windows 7?

900

Why is sql server log file full?

1016

What is a primary index?

911

What is difference between rownum and rowid?

883

When to use Inner join & when to use subquery?

1137

Does group by sort data?

882

Do you know spatial data types - geometry and geography in sql server 2008?

1004

what is the system function to get current user's user id? : Sql server database administration

979

What is a database in ms sql server?

1035

How to create new tables with "create table" statements in ms sql server?

1039

What is co-related sub query?

1005

What are the advantages of sql stored procedure?

1051