tag:blogger.com,1999:blog-7805972021499203804.post8484265210782411024..comments2023-10-30T06:24:14.411-07:00Comments on ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview: SQL Query to Get Latest Unique Records by DateSuresh Dasarihttp://www.blogger.com/profile/01337689983379917267noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7805972021499203804.post-72957046758366683072014-02-19T00:32:09.567-08:002014-02-19T00:32:09.567-08:00How to Get Latest Updated Records of table??How to Get Latest Updated Records of table??Irappa Pattanashettihttps://www.blogger.com/profile/17550582237964125419noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-84633835538047114062012-12-13T02:00:42.927-08:002012-12-13T02:00:42.927-08:00
WITH TEMP
AS
(
SELECT ROW_NUMBER() OVER(PARTITIO...<br />WITH TEMP<br />AS<br />(<br /><br />SELECT ROW_NUMBER() OVER(PARTITION BY CATEGORY_ID ORDER BY PURCHASED_DATE DESC) AS RNO,CATEGORY_ID,PRODUCT_NAME,PURCHASED_DATE FROM PRODUCAT_TABLE<br />)<br />SELECT * FROM TEMP WHERE RNO=1PRINCEhttp://www.thetist.comnoreply@blogger.com