A perplexing QUERY 
Author Message
 A perplexing QUERY

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

Would a set help?  The manual is confusing in its explanation.

Thanks in advance.



Wed, 03 Jul 1996 00:56:08 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Perplexing Query

2. Perplexing Query Performance

3. A Perplexing Query

4. SQL Query Question - Perplexed Me for Days

5. Perplexing SQL Query

6. FPW26 Query Problem - I'm perplexed

7. A perplexing SQL Server problem

8. perplexing SQL authentication from ASP.net issue

9. this very perplexing problem.

10. this very perplexing problem

11. Perplexed with NT and SQL Server security

12. Perplexing Problem!


 
Powered by phpBB® Forum Software