SELECT * FROM PRODUCT WHERE ROWNUM< 50 ORDER BY CREATED DESC

minus

SELECT * FROM PRODUCT WHERE ROWNUM< 20 ORDER BY CREATED DESC


is to have error....am i suppost to do a sub select?

This post has been edited by lonewolf: Feb 23 2006, 03:20 PM

and the error is..?? and what exactly you want to achieve?

I think he wants to subtract from a result from one query from another query though I don't quite understand whether is it really.

This question is too vague.

This post has been edited by rukawa: Feb 23 2006, 08:03 PM

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

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.



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

haha..that doesn work...

anyway i found the solution..is slightly more complex

here is the answer

select * from
(
select p.*,rownum row_num from (
select * from PRODUCT order by DATE desc
) p
) where row_num between 20 and 50

That seems overly complicated to me. Why not use:



You can cut out one nested statement this way.

Ok, some beautification on you guys codes.

Why not place all your SELECT* ,,, as VIEWS and call those VIEWS.

It hurts my eyes when I see all those SELECT here and there. (nested)

Because he may not have permission to create views in the database?