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

How can you insert values in multiple rows using one Insert statement?

1152

Explain about SQLOS?

1061

What is proper subset of candidate key?

1045

What is extended stored procedures?

1029

What is spid in sql server profiler?

1170

How do I manually uninstall an instance of sql server 2016?

1082

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1105

Detail about query optimizer?

1160

Can a table have 2 foreign keys?

959

How to rename an existing column with sql server management studio?

1055

How many columns can we include on clustered index ?

1060

What is intellisense?

1102

Describe and explain about SQL native client?

1159

What is sql language?

1234

how can you check the level of fragmentation on a table? : Sql server administration

1041