Everything you need to know about backup and disaster recovery with AWS, for FREE!
SELECT Count(DATEPART(yyyy,DOB)) As 'UserCount' , DATEPART(yyyy,DOB) As 'Year' , (DATEPART(yyyy,GETDATE()) - DATEPART(yyyy,DOB)) As 'Age' FROM [User] u WHERE DATEPART(yyyy,DOB) IS NOT NULL GROUP BY DATEPART(yyyy,DOB) ORDER BY DATEPART(yyyy,DOB) DESC
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|I am writing a Stored Procedure using SQL Server 2008. Do you know how I can resolve the error: Must declare the scalar variable "@sBank" ?||7||39|
|How to use Recordset, returned from a SPROC as the recourdsource of a form.||24||49|
|T-SQL: Trying to use a "NOT IN (Subquery)" in CASE Statement||2||29|
Join the community of 500,000 technology professionals and ask your questions.