vbnetcoder
asked on
max for a segment
I have a table like this
NAME , SegDate, Segment
I need to select the records where the latest segdate per NAME is <> 'JK' but where they do have a segdate that is not in the past
NAME , SegDate, Segment
I need to select the records where the latest segdate per NAME is <> 'JK' but where they do have a segdate that is not in the past
can you please provide few rows and expected output.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ty