MS SQL

MS SQL RSS

Meeting at least n criteria from given criteria

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Aug 2008

Posts: 1,160

Reputation: dickersonka will become famous soon enough

Solved Threads: 137

dickersonka dickersonka is offline

Offline

Veteran Poster

Re: Meeting at least n criteria from given criteria

#11

Sep 10th, 2008

once again you need to group by using the outer query

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
FROM ships WHERE classes.class=ships.class)
-- note the end parenthese
-- now put your group by and total
GROUP BY name, classmatch, borematch, displacementmatch, countrymatch, launchedmatch, typematch, numgunsmatch
WHERE total>=4
from ships where classes.class=ships.class)
-- note the end parenthese
-- now put your group by and total
group by name, classmatch, borematch, displacementmatch, countrymatch, launchedmatch, typematch, numgunsmatch
where total>=4