>So, let me re-iterate a bit.
>- The first select is the general search where I'm selecting 3 from
>the total and I list the columns that I want. I want all of them,
>but it's still better to directly list them both for readability and
>accuracy.
>- The second select is pulled out of the first select's returns and
>it returns them ordered and such.
>Or do I have this reversed mentally?
This is the only one you got mixed up. The inner SELECT (the one in the FROM
clause) actually runs first, and the the outer SELECT simply takes the top 3
records returned from the result set.
>- I like the <= 3 for too.
>- Nice to know about the sysdate. I remembered that there was
>something like it the last time I used Oracle but had forgotten.
>Nice a clean to read.
>
>
>I learned alot, thanks.
Very welcome.
Regards,
Dave.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
