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

Explain private assembly?

868

Did vb6 support multi-threading ?

910

Explain option explicit?

962

What is the difference between compiler and interpreter?

970

What is strong typing and weak typing?

958

What is datatype conversion?

1046

What are jagged arrarys ?

923

How many classes a dll can contain?

944

Write a program to find all text files in a logical drive and return the count of the number of files?

2662

how to get dynamic control array position or its index position?

2466

what is diffrence constructor and destructor in vb

910

What is strong name in .net assembly?

921

What are the two main parts of .net?

951

Name the two main parts of .net?

889

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 ?

2601