18 years in and I just learned about it today
Old dogs... new tricks... who says it can't happen? :) I know the feeling.
Dennis Powers
UXB Internet - A website Design and Hosting Company
P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844
W: http://www.uxbinternet.com
W:
I hope this saves someone some time and I hope I'm not way late to the
RANK() party:
Let's say you have this table:
column1 - column2
A - 1
A - 2
A - 2
B - 3
B - 4
B - 4
...and you need to write SQL to return the most frequently occurring
column2 for each distinct column1:
A - 2
B - 4
Enter
Nice!
I've never heard of Rank()...
On 8/12/2014 4:21 PM, John M Bliss wrote:
I hope this saves someone some time and I hope I'm not way late to the
RANK() party:
Let's say you have this table:
column1 - column2
A - 1
A - 2
A - 2
B - 3
B - 4
B - 4
...and you need to write SQL to
Happy to not be the only one. 18 years in and I just learned about it today
(IIRC). :-)
On Aug 12, 2014 8:49 PM, Rick Faircloth r...@whitestonemedia.com wrote:
Nice!
I've never heard of Rank()...
On 8/12/2014 4:21 PM, John M Bliss wrote:
I hope this saves someone some time and I hope
4 matches
Mail list logo