How do I include a text (or ntext) field in a query that uses an aggregate function
SELECT textField, someOtherField, COUNT(anotherFieldAgain) AS Total
GROUP BY textField, someOtherField
In MS access I could use the FIRST or LAST function to do this (on a SQL Server back-end) - and not include it in the group by clause. How do I do this in SQL Server?