sql satement for 2nd maximum value

Answer Posted / avnish

create table emp with row empsal having the datatype float
and insert some salary
now to get the second max salary
write the sql statement

select max(empsal) from emp where empsal<(select max(empsal)
from emp)
its asubquery

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the advantages of VB.NET?

598


Can you please explain the difference between c# and vb.net?

539


what is intermediate language?

610


What is branching logic control in VB.NET?

570


Explain convert.tostring and i.tostring method?

527






What is code access security?

686


What are the different variables in vb.net?

518


thak you Mr Govind for replying to my question. My next question is that how to retrieve image stored in an SQL server table and assign it to any image control or picture control using VB.net

1703


i am attending to US consulate i kept my projects on vb.net ,please help me what questions will be ask on vb.net in us consulate

1914


Explain the difference between dispose and finalize()?

553


Tell me which namespace are used for accessing the data?

523


What is the main purpose of garbage collector?

504


what is diffrence constructor and destructor in vb

550


What is strong name in .net assembly?

533


What is the advantage of using system.text.stringbuilder over system.string?

606