Post #863 
Author Message
 Post #863

I didn't think post #863 was too much of a twinkie-head question.  But maybe
it was too challenging...

It is included below:

============================================================================
What query would I use to get a count of everyone with "hoco" for the first
four letters vs everyone else (unique occurrences of other zip codes)?

eg,

=======
 Table
=======

Name    Address
====    =======
John    hoco21044
Betty   21225
Annie   21725
Kelly   21225
Jean    hoco 21046
Alain   hoco21046

================
 Desired Result
================

Address Count
======= =====
hoco    3
21225   2
21725   1
============================================================================

In other words, "hoco.." is unique and every other distinct zip code is unique.



Fri, 05 Jul 1996 02:55:41 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. SQL Travel Timetables repost [post post post apology etc]

2. Travel Timetables repost [post post post apology etc]

3. why does post not always post?

4. Edit+Post much slower than Insert+Post !

5. OT: Top post v. bottom post

6. Don't open the previous Post is off topic, i'm sorry i post it in the wrong ng

7. Post posts but doesn't post! Why?!

8. Bug? Append, Post, Edit, Post and the data is no more to be seen....

9. Post posts but doesn't post! Why?!

10. Test Post by wadejer

11. test post

12. test post


 
Powered by phpBB® Forum Software