Great website
Watch online Movies
Listen songs
Live Tv Channels
Telugu,Hindi,Tamil,Kannada,Panjabi,Bengali,Marathi
Great website
Watch online Movies
Listen songs
Live Tv Channels
Telugu,Hindi,Tamil,Kannada,Panjabi,Bengali,Marathi
--group by day
SELECT COUNT(* ),
Dateadd(DAY,Datediff(DAY,0,HireDate),0) 'day'
FROM Employees
GROUP BY Dateadd(DAY,Datediff(DAY,0,HireDate),0)
ORDER BY Dateadd(DAY,Datediff(DAY,0,HireDate),0) DESC
--group by Month
SELECT COUNT(* ),
Dateadd(MONTH,Datediff(MONTH,0,HireDate),0) 'Month'
FROM Employees
GROUP BY Dateadd(MONTH,Datediff(MONTH,0,HireDate),0)
ORDER BY Dateadd(MONTH,Datediff(MONTH,0,HireDate),0) DESC
Popular Posts
|