Well... kind of the reverse. The SAMPLE keyword with SELECT will give you the first n records. But remember that UV stores records using a hashing algorithm, so the first n records won't be meaningfully different from the last n records.
SELECT file SAMPLE 100 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Andrew E. Tegenkamp Sent: Thursday, February 18, 2010 12:50 PM To: [email protected] Subject: [U2] TOP/LIMIT Equivalent? In UniVerse, I can't seem to find the syntax like MSSQL's SELECT TOP 100 or MySQL's LIMIT 100 clause. Does UniVerse have this syntax somewhere I'm not seeing in the documentation? I'm just trying to pull out the last 100 records of a table and export them out as a sample. Thanks, Andrew ............................................... Andrew E. Tegenkamp Director, Systems Integration G3 Systems, Inc. P:540.951.4300 F:540.951.4311 http://www.g3.com _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
