Member Avatar for jacob21

Hi,
Can we use count inside case statement.
Need suggestions..

Error: ER_INVALID_GROUP_FUNC_USE: Invalid use of group function

select COUNT(case when count(c3.id)>1 then c3.id end) as more_then_one
......................
...........................
  • 2 Contributors
  • 1 Reply
  • 98 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by urtrivedi
Member Avatar for urtrivedi

when your condition is based on function result, you need to use having keyword

select grpcol1, grpcol2, count(c3.id) from table1 group by grpcol1, grpcol2 having count(c3.id)>1
Edited by urtrivedi
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.