Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 Oracle select statement

views
     
anthony_yio
post Feb 24 2006, 07:07 PM

........
Group Icon
Elite
1,828 posts

Joined: Jan 2003


QUOTE(fly @ Feb 24 2006, 02:43 PM)
That seems overly complicated to me. Why not use:

CODE
select * from (
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.
*
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)



 

Change to:
| Lo-Fi Version
0.0139sec    0.41    6 queries    GZIP Disabled
Time is now: 29th March 2024 - 08:58 AM