I'm using UniData 6. Is there a UniData SQL equivalent to the UniQuery SAMPLE keyword?
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: http://old.nabble.com/Is-there-a-UniData-SQL-equivalent-to-the-UniQuery-SAMPLE-keyword--tp32375954p32375954.html Sent from the U2 - Users mailing list archive at Nabble.com. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users