Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Hi,
>
>The results should be :
>
>We did not know the first name is JOE, JAY or JAR, JAN, JIL, JUL.....
>
>The six ID below are different and must be show up in the results of SQL syntax.
>
>First name below is JOE:
>
>JDOE19601231001 mycity
>JDOE19601231002 yourcity
>JDOE19601231003 hiscity
>
>Fist name below is JAY:
>
>JDOE19601231001 joecity
>JDOE19601231002 jaycity
>JDOE19601231003 ourcity
>
>The city's name must be completely different to prove they were different persons ID.
I'm still not totally sure what you're looking for, but it looks like SELECT DISTINCT should give you what you need.
Tamar
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement