On Mon, Aug 26, 2013 at 3:17 AM, gajendra s v <svgajendra@xxxxxxxxx> wrote:
Please explain me why it is ?
A good place to start would be removing all the parts here that don't seem to matter. Your problem seems to be with the recursive query (since that is the part you're changing). Cut off everything else and compare the results of the recursive queries, and if you still can't figure it out, come back here with your findings (and the isolated recursive queries). You'll be much more likely to get responses if you narrow down the problem you're having instead of asking people on this list to do it.
You might find this a good read: http://sscce.org/. And it wouldn't hurt if you could create a SQL Fiddle that demonstrates your problem; the simpler and more trimmed down the better.
