Select record using DateDiff function in where clause in SQL Server

Question

HiMy Sample table in MSSql database is as underCom                       DCCompany1          452021Company2          562021Company3          562021Company3          582021Company5          592021Company4          592021Company2          592021Company6          392021Company7          292021Company8          192021Company9          1192020Company8          5102021I am trying to derive a gridview with list of companies from above database where MAXDC is gt 120 daysMy

sat · Accepted Answer

HiI resolved it by changing my select statement as underSelect  From Select Com MAXDC DC FROM DSR Group By Com As DSR Where DATEDIFFDayDCGETDATE gt 120 Order By DC ASCI used subquery and it worked wellThanks again

dharmendr · Answer

You can do it with where conditionRefer below querySQLDECLARE DSR AS TABLECom VARCHAR15DC VARCHAR10INSERT INTO DSR VALUES39Company1393945202139INSERT INTO DSR VALUES39Company2393956202139INSERT INTO DSR VALUES39Company3393956202139INSERT INTO DSR VALUES39Company3393958202139INSERT INTO DSR VALUES39Company5393959202139INSERT INTO DSR VALUES39Company4393959202139INSERT INTO DSR VALUES39Company2393959202139INSERT INTO DSR VALUES39Company6393939202139INSERT INTO DSR VALUES39Company7393929202139INSERT INTO DSR VALUES39Company8393919202139INSERT INTO DSR VALUES39Company93939119202039INSERT INTO DSR VALUES39Company83939510202139SELECT  FROM DSR WHERE DC IN SELECT MAXDC DC FROM DSR GROUP BY Com AND DATEDIFFDAYDCGETDATE gt 120 ORDER BY DC ASCOutput    Com

Select record using DateDiff function in where clause in SQL Server

Company

Explore

Follow us

Contact Us