Viewing 6 posts - 16 through 21 (of 21 total)
Thank You Steven, this worked great. I never thought of using PARTITION method. 🙂
July 12, 2013 at 7:32 am
Hi
This query returns the same values for both the min and max date.
July 12, 2013 at 7:30 am
ScottPletcher (4/1/2013)
SELECT
, segment, value
FROM (
SELECT
, segment, value,
...
April 2, 2013 at 7:47 am
David Webb-200187 (4/1/2013)
Something like:
select key, segment, max(value) from whatevertheheckyourtablenameis
group by key,segment
order by key,segment
That does not work, it does remove the records that does not have the max value. It returns...
April 1, 2013 at 3:44 pm
I am having the same issue, have you found the solution. Thanks.
November 22, 2010 at 9:01 am
Viewing 6 posts - 16 through 21 (of 21 total)