select * from tabl1 where salary=(select max(salary) from tabl1 where sala

find 2nd highest salary of person using cursor concept?

Question Posted / b.mamatha

Answer Posted / b.mamatha

select * from tabl1 where salary=(select max(salary) from
tabl1 where salary<(select max(salary) from tabl1)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are indexes in ms sql server?

996

What are the reporting services components?

130

how can u get last observation in an unknown dataset ?

2387

What are database states in ms sql server?

1113

Explain how many normalization forms?

967

What stored by the tempdb ? : sql server database administration

1005

What is the difference between dropping a database and taking a database offline?

1115

How you trouble shoot when any job fails

1894

How you can find out if an index is useful to the optimizer?

870

What is a trigger and types of a trigger?

923

What are the properties and different types of sub-queries?

958

Explain filestream storage of sql server 2008?

950

What are pages and extents? : SQL Server Architecture

956

Can we call stored procedure in view in sql server?

859

What are the basic functions for master, msdb, model, tempdb databases?

988