Home » SQL & PL/SQL » SQL & PL/SQL » NTILE Issue
NTILE Issue [message #585372] Fri, 24 May 2013 07:25 Go to next message
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.
Re: NTILE Issue [message #585388 is a reply to message #585372] Fri, 24 May 2013 10:25 Go to previous messageGo to next message
fakru.y
Messages: 34
Registered: May 2007
Member
i got what i'm asking. thanks
Re: NTILE Issue [message #585390 is a reply to message #585388] Fri, 24 May 2013 10:26 Go to previous messageGo to next message
Michel Cadot
Messages: 59821
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So what is the solution?

Regards
Michel
Re: NTILE Issue [message #597061 is a reply to message #585390] Mon, 30 September 2013 12:26 Go to previous message
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.
Previous Topic: Combining rows in data file based on values in control file
Next Topic: REGEXP_SUBSTR
Goto Forum:
  


Current Time: Fri Nov 28 21:46:25 CST 2014

Total time taken to generate the page: 0.09595 seconds