Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Returning DISTINCT rows when SQL *DOES NOT* contain distinct!
DA Morgan wrote:
>
> You make me just want to suggest:
>
> SELECT UNIQUE id
> FROM ....;
>
> Also doesn't contain the keyword word DISTINCT.
>
> Why hasn't anyone asked the OP what the point of the exercise is? I
fail
> to see a premise beyond "my instructor gave me homework."
:-)
Hmmm... Not a good idea to write off every query as "my instructor...".
We are trying to optimize the response time from a mission critical tool, which bogs down when it gets the result set contains hundereds (or thousands) of rows while it should only contain may be 10 or 20!!!
regards, Received on Sat May 14 2005 - 16:13:51 CDT