Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 Oracle select statement

views
     
Marcus
post Feb 23 2006, 11:48 PM

Getting Started
**
Junior Member
286 posts

Joined: Jan 2003
From: Subang Jaya


It looks like you wanna extract data between rownum 20 to 49, rite? wink.gif

In a more simpler manner, i think the query should be like :

SELECT * FROM PRODUCT
WHERE ROWNUM BETWEEN 20 AND 49
ORDER BY CREATED DESC;

Try this and see. I don't think a sub-query is necessary. smile.gif



This post has been edited by Marcus: Feb 24 2006, 12:01 AM

 

Change to:
| Lo-Fi Version
0.0139sec    0.29    6 queries    GZIP Disabled
Time is now: 29th March 2024 - 12:11 AM