Problem using Min(field)
- by Todd
have these two queries:
SELECT classroomid AS crid, startdate AS msd
FROM unitTemplates where classroomid = 6
GROUP BY classroomid
and:
SELECT classroomid AS crid, Min(startdate) AS msd
FROM unitTemplates where classroomid = 6
GROUP BY classroomid
The second query uses the minimum function. There is only one record in my table with a…