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

Can you please explain the difference between thread and process?

732


Explain the use of option explicit?

772


Explain global assembly cache (gac)?

916


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

1868


Which is the tool which can convert visual basic old version to .net compatibility version?

704


Define serialization in .net?

809


Explain trace in vb.net?

721


Explain the difference between vb 6 and vb.net?

729


What are the features present in vb 2005?

742


What is option strict?

682


What is non_deterministic finalization?

829


What is sorting in vb?

667


What is sealed class?

803


What is the strong name in .net assembly?

751


What is jagged array in vb.net?

829