pk fk date -- -- ---- 1 1 1/1/1976 2 2 1/2/1976 3 2 1/1/1969 4 1 1/15/1976 5 1 1/15/2006 6 1 8/10/1989 7 2 12/25/2005 . . .In my result set I would like 2 records per unique FK, one record is the min date and the other record is the max date. For the example above the result would look something like this:
pk fk date -- -- ---- 1 1 1/1/1976 3 2 1/1/1969 5 1 1/15/2006 7 2 12/25/2005Is what I am asking possible? Would I be able to use UNION (first get all the min dates and then all the max dates)?