Reputation: 0 Apprentice
- New Members
- Active Posts:
- 7 (0.01 per day)
- 13-June 12
- Profile Views:
- Last Active:
- Dec 06 2012 02:32 PM
- Dream Kudos:
Posts I've Made
Posted 15 Oct 2012Hey.
To do that you should use a GROUP BY ... HAVING clause, instead of DISTINCT. Something like:
SELECT Piece_ID FROM PlayerGamePieces GROUP BY Piece_ID HAVING COUNT(Piece_ID) <= 2;
The GROUP BY clause will ensure that only distinct values of the Piece_ID field appear in the result set. The HAVING clause acts as a WHERE clause, but with the ability to use aggregate functions to filter the set.
Posted 14 Jun 2012Dormlich - You're not helping.
Anyone else want to ad a comment?
I'm thinking something along the lines of a timed session variable? JSON?
I guess my question shouldn't have been "Is this easy?", but more like "Can someone please offer me some pointers on how to get started?"
- Member Title:
- New D.I.C Head
- Age Unknown
- Birthday Unknown
Nolan_ hasn't added any friends yet.