Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Question
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL Question
Miscellaneous
Thread ID:
00197746
Message ID:
00197746
Views:
48
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
Next
Reply
Map
View

Click here to load this message in the networking platform