1)Select Max(Total) from mark 2)select top 1 total from ( select top

sql satement for 2nd maximum value

Question Posted / jacob

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

Please Help Members By Posting Answers For Below Questions

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

654

What’s the difference between private and shared assembly?

689

What is the differnce between managed code and unmanaged code?

536

Which namespace are used for accessing the data?

642

Can you please explain the difference between dispose and finalize()?

504

Explain internal keyword in .net framework?

568

What are the differences between vb.net and c#, related to oops concepts

572

How do you retrieve the customized properties of a .net application from xml .config file?

516

What is writeline in vb.net?

525

What is the main use of a namespace?

513

What is the exact defination of object?

573

How to view an assembly?

594

What is branching logic control in VB.NET?

570

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

517

How to create a constant in vb.net?

594