Oracle certifications - help on this question please

Author

help on this question please

sid456

2002-03-09, 3:59 am

Which statment could require a sort first
before you can get the correct result?

a. SELECT DISTINCT product_id
from Product;

b. SELECT product_id, name
from Product
where product_id between 1000 and 2000;

I thought it should be b, but not sure.

Please help!

Ian_J

2002-03-09, 3:10 pm

Select distinct statements require a sort.

laloca

2002-03-09, 5:28 pm

Hi Sid,

a. requires a sort ;-)

I sent you an extra mail acoording to your question from Friday ...

sid456

2002-03-09, 6:00 pm

Really appreciated your help!

Sponsored Links