sql satement for 2nd maximum value

Answer Posted / suresh

department as table name,sfee as column name
SELECT TOP (1) sfee
FROM DEPARTMENT
WHERE (SFEE IN
(SELECT TOP (2) SFEE
FROM DEPARTMENT AS
DEPARTMENT_1
ORDER BY SFEE DESC))

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is common language specification?

592


What is global assembly cache (gac)?

640


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 ?

2323


How do you use two datareaders at the same time in a vb.net windows application ?

643


Explain convert.tostrin?

728






Explain the advantages of migrating to vb.net?

590


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

636


Describe about visual basic.net?

636


Explain global assembly cache (gac)?

801


described weak typing?

676


What are different types of jit ?

673


What is the differences between dataset.clone and dataset.copy?

713


source code for how to login a vb.net application ?

666


Explain redim keyword?

644


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

648