Tag Archive for 'order by'

TSQL Challenge #11 Using Recursive CTE

Add a comment
July 28th, 2009 by Waldar

Here is my proposal about the TSQL Challenge #11.
Given a product table, and a coupon table, we have to find within one or two coupons which combination gives the best discount, with additional rules :

the discount price can not be less than 70% of the original price
the total amount of the discount can [...]

SQLing , , , , .

Oracle KEEP function Order By Keyword

Add a comment
July 17th, 2009 by Waldar

I found something funny with the Oracle Keep / { First - Last } analytic function, on 11.0.0.6 & 11.0.0.7.
Same thing occurs also on Oracle 10g XE.
For those who don't have a clue about this function, I wrote a small post on this subject.

SQLing , , , .