OraFAQ Forum: SQL & PL/SQL » NTILE Issue

Home » SQL & PL/SQL » SQL & PL/SQL » NTILE Issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

NTILE Issue [message #585372]

Fri, 24 May 2013 07:25

fakru.y
Messages: 34
Registered: May 2007

Member

Hi,
I'm trying to assign buckets 1 to 8 to month_id values stored in one of my table using NTILE function. for the same month_id it is assigning two buckets ex for 201211 bucket value is assigning as 1 and 2 both. i do not understand why is this? Please explain.

my requirement is i do have week_id (106 weeks)/month_id (72 months) where i need to assign buckets 1 to 8, when i do this as i said above for the same week/month it is assigning two buckets.

Report message to a moderator

Re: NTILE Issue [message #585388 is a reply to message #585372]

Fri, 24 May 2013 10:25

fakru.y
Messages: 34
Registered: May 2007

Member

i got what i'm asking. thanks

Report message to a moderator

Re: NTILE Issue [message #585390 is a reply to message #585388]

Fri, 24 May 2013 10:26

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So what is the solution?

Regards
Michel

Report message to a moderator

Re: NTILE Issue [message #597061 is a reply to message #585390]

Mon, 30 September 2013 12:26

fakru.y
Messages: 34
Registered: May 2007

Member

i did a distinct on my week_id/month_id list, initially i did not notice that my week list/month list hsa dupes.

Report message to a moderator

Previous Topic:	Combining rows in data file based on values in control file
Next Topic:	REGEXP_SUBSTR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 13:57:38 CDT 2024