sql satement for 2nd maximum value

Answer Posted / jacob

1)Select Max(Total) from mark


2)select top 1 total from
( select top 2 total from mark order by total desc ) as
result order
by Total

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is interface and when it is used?

1904


Explain about branching logic control in vb.net?

608


Explain convert.tostring and i.tostring method?

597


Explain the services provided by common language infrastructure.

813


Explain about visual basic.net?

748






Explain the use of serialization and deserialization?

609


Define serialization in .net?

715


What are all the parts of .net framework?

610


Explain how to achieve polymorphism in vb.net?

625


What is the importance of a Button control?

968


Why do we use byref keyword in vb.net?

696


What do you mean by serialization and deserialization?

618


Which properties are used to bind a DataGridView control?

658


What are option strict and option explicit?

906


What are the difference between dispose(), close(), exit(), end()? When do we use them?

636