Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Question
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL Question
Divers
Thread ID:
00197746
Message ID:
00197746
Vues:
50
I have a table with 3 fields:

Id C(8), LastName C(25), FirstName C(25)

What's the SQL command to retreive only unique
last names from the table?

I tried the following:

select distinct lastname, id, firstname from
mytable order by lastname into cursor x

But I don't get unique last names.

TIA
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform