Count(*) error

Count (*) gives an error;

 is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT IET.[ICol1]
      ,IET.[Col2]
    
         , ''
         , NULL
         , NULL
         ,  COUNT (*)

FROM [table1] IET  

Open in new window

RIASAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
If all you want is a count, then don't include any other columns:
select count(*) from FROM [table1] IET 

Open in new window


If you want a count returned as part of every row you can use a WINDOW function:
SELECT IET.[ICol1]
      ,IET.[Col2]
    
         , ''
         , NULL
         , NULL
         ,  COUNT (*) OVER()
FROM [table1] IET 

Open in new window

0
 
slightwv (䄆 Netminder) Commented:
You need to group by all non-aggregate columns:
SELECT IET.[ICol1]
      ,IET.[Col2]
    
         , ''
         , NULL
         , NULL
         ,  COUNT (*)
FROM [table1] IET 
group by 
     IET.[ICol1]
      ,IET.[Col2]

Open in new window

0
 
RIASAuthor Commented:
Is there no other way, I just need a count of the rows.
0
 
RIASAuthor Commented:
Perfect! Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.