sql satement for 2nd maximum value

Answer Posted / murli d

author is Table name
ID is column name

select top 1 * from author where ID < (select max(ID)
from author) order by ID desc

Is This Answer Correct ?    16 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is different between web.config and machine.config and where it will be ?

649


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

736


How do you call a stored procedure in Visual Basic?

656


What are the differences between server-side and client-side code?

605


What are the advantages of an assembly?

694






What is branching logic control in VB.NET?

640


What is econo-jit?

691


Write program in VB.Net with SQL Server and Crystal Reports to develop a small windows application to add,edit,save, search and print Employee Information and send sourcecode as zip file. empcode : .............. empname : .............. dateofjoin : dd/mm/yyyy dateofbirth : dd/mm/yyyy TableName: EmpMaster EmpCode EmpName DOB DOJ TableName: EmpDocs EmpCode DocNo DocName ExpDate

2267


Which control is an example of an object in vb net?

6575


What are the technology areas that microsoft.net contains?

643


Name the two main parts of .net?

605


Why do you need Lock in Visual Basic?

720


Define clr?

615


What is an assembly and its use?

626


Explain an assembly?

645