| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Pubcon Platinum Sponsor 2014|
|how do u show a result once?|
I am using the below statment to bring back results for towns beginning with A to E.
SELECT * FROM data1 where town between 'A%' and 'E%' ORDER BY town
But because I multipule entries the results are for example:
How do I get it to return just the one result per town?
Thanks for any help?
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved