Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select Statement: Count IDs in a Specific Term if ID doesn't Exist in Previous Terms

Status
Not open for further replies.
kernal

kernal

Technical User
Joined
Feb 27, 2001
Messages
415
Location
US
Quick sample of table

Person
ID Term
1 1078
1 1082

2 1026
2 1088

3 1078

4 1122
4 1138

I want to count an ID if their first term ends in 8 and don't count them if their first term doesn't end in 8 so results:

Term Count ID
1078 2 (ID 1 and 3)
1088 0 (since ID 2 has their first term ending with 6 they are not included)
1138 0 (since ID 4 has their first term ending with 2 they are not included)

Help is appreciated. Thanks
 
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question Question
function argument value, type or count is invalid
Replies
3
Views
937
bharons
bharons
EdLentz
  • Locked
  • Question Question
How do I use a keyword in a query??
Replies
6
Views
1K
EdLentz
EdLentz
boylesg
  • Locked
  • Question Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
905
spamjim
spamjim
lupidol
  • Locked
  • Question Question
Cannot create new table in mySQL
Replies
6
Views
1K
lupidol
lupidol
Arthur Lewis
  • Locked
  • Question Question
How to effect a NOWAIT in the LOCK TABLES statement?
Replies
0
Views
328
Arthur Lewis
Arthur Lewis

Part and Inventory Search

Sponsor

Back
Top