I'm using UniData 6. Is there a UniData SQL equivalent to the UniQuery SAMPLE
Using UniQuery, I've always been able to do:
SELECT CUST BY NAME SAMPLE 1
and it would give me a the record with the first alphabetical name.
In UniData SQL, I'd like to be able to do something like:
SELECT NAME FROM CUST ORDER BY NAME SAMPLE 1;
...or, as in other SQL databases...
SELECT TOP 1 NAME FROM CUST ORDER BY NAME;
and get just the name of the the customer whose listed first alphabetically.
Is there a keyword like this?
View this message in context:
Sent from the U2 - Users mailing list archive at Nabble.com.
U2-Users mailing list