Now that's a LOT easier than the stuff Bill and I wrote up in Advanced SQL Queries!!
Thanks, Razzak! David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, July 20, 2005 4:18 PM Subject: [RBG7-L] - Using the New "TOP n" Qualifier in SELECT Commands > > Wednesday, July 20, 2005 > > From the Edge: Using the New "TOP n" Qualifier in SELECT Commands > Section: New and Enhanced Commands > Chapter: Running R:BASE Your Way! > Platforms: R:BASE 7.5, V-8 "Turbo", Oterro 3.5/8.0 > Supported Builds: > . R:BASE 7.5 (7.5.11.30720 or higher) > . R:BASE V-8 "Turbo" (8.0.9.30720 or higher) > . Oterro 3.5 and Oterro 8.0 (Private Beta) > > Among major tools, features and enhancements, R:BASE 7.5 for > Windows, R:BASE V-8 "Turbo" for Windows, Oterro 3.5 and Oterro > 8.0, include the support for new "TOP n" qualifier in SELECT > commands. > > New Syntax: > > SELECT TOP n * FROM tablename WHERE whereclause ORDER BY column(s) > > Here is an example: > > To show the top 5 bonuses where the bonus is under $500 from > SalesBonus table in ConComp: > > SELECT TOP 5 * FROM SalesBonus WHERE Bonus < 500 ORDER BY Bonus=DESC > > The "TOP n" goes between the word SELECT and the column list for the > command. > > A PDF version of this document is also available at: > > From The Edge: http://www.razzak.com/fte > (Powered by R:WEB Suite) > > Imagine the possibilities! > > Very Best R:egards, > > Razzak. > > >
