View previous topic :: View next topic
|
Author |
Message |
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
no need to be rude.
At the time of my post about missing order by there was none. It's not my fault that you edit it afterwards and then play innocent.
you have now flooded this thread with a lot of BS and finally came to an answer that was already given in post 5 (which is also missing order by) |
|
Back to top |
|
|
lkhiger
New User
Joined: 28 Oct 2005 Posts: 89
|
|
|
|
GuyC wrote: |
no need to be rude.
At the time of my post about missing order by there was none. It's not my fault that you edit it afterwards and then play innocent.
you have now flooded this thread with a lot of BS and finally came to an answer that was already given in post 5 (which is also missing order by) |
Forget about. It's not interesting for me anymore.
The problem was too easy, but you said ... it is too difficult in V8. See your message.
That's why I shown to author the few ideas how to solve it.
Buy-buy ORDER BY !
Lenny
Lenny |
|
Back to top |
|
|
lkhiger
New User
Joined: 28 Oct 2005 Posts: 89
|
|
|
|
GuyC wrote: |
there's no easy solution for this in V8, especially not when some order is involved.
in V9 you might use quantile runstats to determine the cut off points |
In V9 we can use the function
which is not required KEYID.
Lenny |
|
Back to top |
|
|
|