Nepethya Rana

Nepethya Rana

  • NA
  • 335
  • 145.7k

SQL Query Error while using Group by clause

Jun 19 2017 2:12 PM
What i am trying to achieve is that i want result set returned in two groups for two username with latest data
SELECT TOP(100) id , insertdate, modifieddate, detail, username FROM MyTable
WHERE username = 'AAA' or username='1234'
GROUP BY username
ORDER BY insertdate DESC
But when i run this query i get error :
Column 'MyTable.id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
How do i achieve this?

Answers (3)