InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 02:12:18 GMT20http://www.sqlservercentral.com/Forums/Topic1423396-1292-1.aspxthat's awesome laurie thanks a ton :)Sun, 24 Feb 2013 10:46:11 GMTirfanullahhttp://www.sqlservercentral.com/Forums/Topic1423396-1292-1.aspxSomething like this should do it:[code="sql"]--i have table with following structure.--SELECT SaleID, vender_inv, Code, cDate--FROM SaleMain--i want to fetch last two invoice against each code.--where saleid is auto incremented and cdate as well to get last --invoice.select *from(select SaleId, Vender_Inv, Code, cDate,ROW_NUMBER() over (partition by Code order by cDate Desc) as RowNumberFROM SaleMain ) Awhere A.RowNumber < 3[/code]Sun, 24 Feb 2013 10:27:34 GMTlaurie-789651http://www.sqlservercentral.com/Forums/Topic1423396-1292-1.aspxYou might want to look into the CROSS APPLY syntax (use it to get the Top 2 vender_inv ORDER BY SaleID DESC) together with a cte or subquery to return all distinct code values.Sun, 24 Feb 2013 03:10:07 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic1423396-1292-1.aspxi have table with following structure.SELECT SaleID, vender_inv, Code, cDateFROM SaleMaini want to fetch last two invoice against each code.where saleid is auto incremented and cdate as well to get last invoice. help will be really appreciated.Sat, 23 Feb 2013 23:26:31 GMTirfanullah