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

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

643


What is sorting in vb?

592


Define manifest?

645


What are the types of generations in garbage collector?

617


What is redim keyword and its use?

675






Explain how to store decimal data in .net?

811


Explain cts?

622


what is difference between namespace and assembly?

629


List the types of authentication?

607


What are the advantages of vb.net and c#?

736


hello thank you for replying to my question regarding adding barcode fonts in vb.net project. I have downloaded a free font and added in my vb.net project but now i dont know how to use that i need to generate barcodes can any body help me how to use those fonts these are font3of9 .i need a small code to use these fonts to generate barcode thank u!

1669


What are the shadow variables?

671


what is interface and when it is used?

1904


Explain how does the xmlserializer work?

670


How can we store decimal data in .net?

625