Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Returning a set number of unique elements..
err.. i mean this No, the search wouldn't always be on OrderID.. For example, I'd like to search for all orders related to "tim" and return this: 123, TIM, PRODUCTA 125, TIM, PRODUCTA 125, TIM, PRODUCTC -
Returning a set number of unique elements..
Is it an issue? Well I'd like an SQL version.. I've done a work around in the code that calls the SQL (I just fetch the first X unique order ID rows returned).. Yes, I'd like ranges.. No, the search wouldn't always be on OrderID.. For example, I'd like to search for all orders related to... -
Returning a set number of unique elements..
I've got a problem and my limited SQL knowledge it now being tested, and I'm passing this on to you smart folks.. (Oracle DB).. I have a table with data similar to this where the columns are ORDERID, SALESPERSON, PRODUCTID 123, TIM, PRODUCTA 123, TOM, PRODUCTA 123, MARY, PRODUCTB...
