I have this query that gets a name based on the a begin date in my table <= sysdate and then the end date.
I get one value from the name field when I do this. I would like to get the previous record
So there would be 2 values in the results. Any help would be appreciated.
name2 - previous record
name1
select name
FROM ps_name_tbl
WHERE (begin_dt <= sysdate) and (end_dt >= sysdate) and (career = 'Program')
GROUP BY name, career, begin_dt, end date
ORDER BY name
I get one value from the name field when I do this. I would like to get the previous record
So there would be 2 values in the results. Any help would be appreciated.
name2 - previous record
name1
select name
FROM ps_name_tbl
WHERE (begin_dt <= sysdate) and (end_dt >= sysdate) and (career = 'Program')
GROUP BY name, career, begin_dt, end date
ORDER BY name