http://snipplr.com/language/sql/tags/BY Recent snippets posted on Snipplr.com en-us Sat, 25 May 2013 13:14:01 GMT http://snipplr.com/view/37954/----/

]]> Wed, 28 Jul 2010 00:25:40 GMT http://snipplr.com/view/37954/----/ http://snipplr.com/view/34810/ranking-function--range-over-partition--oracle-analytical-function/ ROW_NUMBER() - Partition (group by) the expression values and assigns integer values to the rows depending on their order. thx to Shouvik Basu < http://www.orafaq.com/node/55 >

]]> Wed, 19 May 2010 14:27:08 GMT http://snipplr.com/view/34810/ranking-function--range-over-partition--oracle-analytical-function/ http://snipplr.com/view/11420/getting-counts-with-a-union-of-two-tables/ I was having the hardest time getting this to work. It's a collection of various items. For whatever reason, I needed to include the CASE statement due to NULL's coming back. If this helps you out... go for it.

]]> Wed, 21 Jan 2009 20:29:40 GMT http://snipplr.com/view/11420/getting-counts-with-a-union-of-two-tables/ http://snipplr.com/view/4076/ordering-multiple-select-statements-in-a-union/

]]> Tue, 06 Nov 2007 08:43:28 GMT http://snipplr.com/view/4076/ordering-multiple-select-statements-in-a-union/