Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

6
  • 1
    Looks like you're missing a closing ')' somewhere. Also, can you provide some sample data? Commented Jan 17, 2013 at 10:14
  • The 2 is the value of the COUNT() or meetingID? The query seems to be logically and syntactically correct. Commented Jan 17, 2013 at 10:24
  • yeh 2 is the count I want to make. how many meetingIDs have 2 caseIDs. This part is working. I just to need to count the rows from this query. I'm just not sure how to make a count of this query. Commented Jan 17, 2013 at 10:27
  • I can't do a sum of these rows because they are displaying 2 so it would give a figure of double what i want Commented Jan 17, 2013 at 10:29
  • Well, if your current query returns a list and all you want is to count the number of rows in the list, just put it inside another subquery and do a count(*). Commented Jan 17, 2013 at 10:49