Using Order by in a Group by statement

Question

is it possible to use a order by clause in a group by statement?

this is my statement

 

SELECT 
	  [Month]
	, Count(*)
FROM
	Students
WHERE
	TotalAttendances = '1'
	AND ([Class] = '5d' 
		Or [Class] = '9s' 
		Or [Class] = '8q' 
		Or [Class] = '1b')
GROUP BY
	  [Month]
ORDER BY 
	AttendanceDate

Answer 1

if you want to use column in order by clause that is not in your select statement then you have to add it in your select.

by the way why you want to use attendaceDate in order when you do not want to show it or use it in count.

---

Shamas Saeed MCITP-DBD 2005 http://sqlservercoollinks.blogspot.com

Answer 2

this ?

SELECT
      [Month]
    , Count(*)
FROM
    Students
WHERE
    TotalAttendances = '1'
    AND ([Class] = '5d'
        Or [Class] = '9s'
        Or [Class] = '8q'
        Or [Class] = '1b')
GROUP BY
      [Month]
ORDER BY
    MAX(AttendanceDate)

---

KH Tan

Answer 3

because the month is out of order

Month (No column name)
Apr 52
Jul 12
Jun 67
May 24

Answer 4

many thanks

Answer 5

This is a design flaw. Class and Attendance are properties of a Schedule.