Hello Guys, Two questions.
1. Would it be possible to implement LIMIT and OFFSET functionality for the databases that support it. Basically to limit the amount of records that are fetched from the database. Oracle unfortunately does not support this, which brings me to 2. 2. Can anyone explain to me how to construct an empire-db query to create the following SQL: SELECT last_name FROM (SELECT last_name, ROW_NUMBER() OVER (ORDER BY last_name) R FROM employees) WHERE R BETWEEN 51 and 100; Note the Oracle function ROW_NUMBER() in the subselect statement. Thanks in advance. :) ---Jaco ##################################################################################### Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any system and destroy any copies. Thank You. ##################################################################################### ##################################################################################### This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal #####################################################################################
