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 tracing?

611


Compare c# and visual basic.net?

546


Explain about the ruby interface generator?

550


Explain the services provided by common language infrastructure.

719


What is writeline in vb.net?

525






Is vb.net a programming language?

534


What is multiple form in vb?

457


Can you please explain the difference between value and reference types?

523


Explain about delegate?

513


Why do you need Lock in Visual Basic?

611


Is vb.net dead?

522


What is strong typing and weak typing?

543


Explain how does the xmlserializer work?

594


What is the source code for display the picture in button click event?

706


Explain about globalization?

500