Thursday, April 23, 2015

Get data for first date and last date

SELECT DBName, Cursize, Gatherdate, Serversname FROM DBGrowthRate
WHERE
Gatherdate = (SELECT MAX(Gatherdate) FROM DBGrowthRate)
OR
Gatherdate = (SELECT MIN(Gatherdate) FROM DBGrowthRate)
ORDER BY Gatherdate


No comments:

Post a Comment