I do not know of a count limiter but you can do a mask on volume_name with the LIKE predicate. You would add LIKE 'XXX%' or LIKE '__X%' for example. % is the splat, _ is the placeholder.
-----Original Message----- From: Henrik Wahlstedt [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 4:06 AM To: [EMAIL PROTECTED] Subject: select statement Hi ! What can I write after DESC if I just want to see my first 10 volumes? 'select volume_name,read_errors + write_errors as error,access from volumes order by error desc' regards Henrik ------------------------------------------------------------------- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
