Torna al Thread

SELECT MINDATA.VRDOCID, MINDATA.DATAINIZIO, MAXDATA.DATAULTIMA FROM (SELECT MIN(VRDATA) AS DATAINIZIO, VRDOCID FROM [dbo].[TDPreventivi] GROUP BY VRDOCID) MINDATA INNER JOIN (SELECT MAX(VRDATA) AS DATAULTIMA, VRDOCID FROM [dbo].[TDPreventivi] GROUP BY VRDOCID) MAXDATA ON MINDATA.VRDOCID = MAXDATA.VRDOCID
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5