sql satement for 2nd maximum value

Answer Posted / cherran

select top 1 sal from
( select top 2 sal from test order by sal desc ) as kk order
by sal

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is break mode? What are the options to step through code?

558


Explain the advantages of migrating to vb.net?

514


Name some of the features present in vb 2005?

578


What do you mean by serialization?

543


Explain how to achieve polymorphism in vb.net?

553






Explain the differences between vb.net and c#, related to oops concepts?

531


Explain how can we remove handlers at run time?

557


What are the features of c# which are not present in vb.net?

662


Allowed program to auto-correct the database when loading a presentation.

1755


i have two class that contain's two methods as same name in derived class i have to call these two methods what will happen at run time ?

2250


Explain the difference between .dll extension and .exe extension files?

532


What is the significance of delegates. Where should they be used? What are the situations where we require them?

541


What is the role of new keyword?

643


How a base class method is hidden?

625


What is the difference between value and reference types?

553