Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

Query Count

Experts, I'm using the query below to pull data from the db, and want to add a clause of WHERE count(misconcepion) >=4, but I keep getting an error when I do.  Can someone tell me how to add this clause to my query?

Thanks
Nick

query:

SELECT ss.studentID, s.fName,s.lName, count(misconception) AS misc
FROM studentmisconceptionreport ss
INNER JOIN students s on s.studentID = ss.studentID
WHERE itemsetID = 65
group by ss.studentID
0
nmarano
Asked:
nmarano
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you wnat:
SELECT ss.studentID, s.fName,s.lName, count(misconception) AS misc
FROM studentmisconceptionreport ss
INNER JOIN students s on s.studentID = ss.studentID
WHERE itemsetID = 65
group by ss.studentID
HACING count(misconception)>=4

Open in new window

0
 
nmaranoAuthor Commented:
Angel thanks!  I'll give it a try now
0
 
nmaranoAuthor Commented:
Thank you sir!  Much appreciated!
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now