QUOTE(fly @ Feb 24 2006, 02:43 PM)
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.CODE
select * from (
select p.*,rownum row_num from PRODUCT where row_num < 50 order by DATE desc
) where row_num > 20
select p.*,rownum row_num from PRODUCT where row_num < 50 order by DATE desc
) where row_num > 20
You can cut out one nested statement this way.
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)