locked
Grouping by age RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello, I'm trying to write a SQL command for grouping different age ranges and using them in a chart.

    SELECT Unvan, COUNT(*), FLOOR(DATEDIFF(day, Birthdate, GETDATE()) / 365.25)  AS Yas FROM Personel WHERE Birthdate BETWEEN '01.01.1978' AND '01.01.1989' GROUP BY Unvan, Birthdate

    But this query makes it like below. I want to Combine all those titles and show them like "There is 10 Technician at age 25."

    Title - Count - Age
    Technician 1    25
    Technician 1    25
    Technician 2    24
    Technician 1    24
    Technician 1    24
    Technician 1    24

    Friday, March 23, 2012 9:41 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote 
    SELECT		Unvan,
		COUNT(*) AS Items,
		Yas
FROM		(
			SELECT	Unvan,
				FLOOR(DATEDIFF(DAY, Birthdate, GETDATE()) / 365.25) AS Yas
			FROM	dbo.Personel
			WHERE	Birthdate BETWEEN '01.01.1978' AND '01.01.1989'
		) AS d
GROUP BY	Unvan,
		Yas

    N 56°04'39.26"
    E 12°55'05.63"

    • Proposed as answer by Naomi N Friday, March 23, 2012 2:03 PM
    • Marked as answer by KJian_ Thursday, March 29, 2012 9:04 AM
    Friday, March 23, 2012 9:48 AM