SQL query challenge!

From: Ken <bballdestroyer_at_yahoo.com>
Date: 23 Aug 2002 11:11:44 -0700
Message-ID: <179c0f9.0208231011.3117155a_at_posting.google.com>

Hello all - this seems to be an easy problem - but I'm stumped. What I need is a *single* SQL statement/query that can give me the zip code that corresponds to the greatest # of houses for each route. Here's an example:
ZIP RTE #HOUSES

101     1     100
102     1     200
103     1     175
 
104     2     200
105     2     675
106     2     700

etc....
The query would return:

ZIP    RTE     #HOUSES
102      1      200
106      2      700

etc......

Can anyone figure this out? I would be love to see a solution! Thanks,
Bill Received on Fri Aug 23 2002 - 20:11:44 CEST

This message: [ Message body ]
Next message: justme: "Re: SQL query challenge!"
Previous message: javaq: "Switch off comments display in SQL*Plus when a script is run"
Next in thread: D.Y.: "Re: SQL query challenge!"
Reply: justme: "Re: SQL query challenge!"
Reply: Kevin McDaniel: "Re: SQL query challenge!"
Reply: Rauf Sarwar: "Re: SQL query challenge!"
Reply: Pramod Ramachandran: "Re: SQL query challenge!"
Reply: D.Y.: "Re: SQL query challenge!"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message