did u tried this query every buddy has given query for selecting rows in a table wht actully u want we r not getting it
select * from Person.Address where AddressID = (select MAX(AddressID)-1 from Person.Address) this query surely gives the 2nd highest row in table pleas can you tells us what are the column names of your table so that we can help you -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
