select *
from
(
    select 
        employee, 
        fld_nbr, 
        date_stamp,
        ROW_NUMBER() OVER (PARTITION BY employee ORDER BY date_stamp DESC) AS RowNum
    from 
        hrhistory
    Where 
        fld_nbr = '2'
        and date_stamp > (sysdate-30)
) as t
where
    RowNum IN (1, 2)

quote:

---

Originally posted by bhussey

Hello, I am trying to create a query that will query any action changes made within the last 30 days. Let's say someone changes their name, I'd like to pull their current name/record and the previous name/record.

This is the query used to pull the current record
select employee, fld_nbr, date_stamp
from hrhistory
Where fld_nbr = '2'
and date_stamp > (sysdate-30)

---

quote:

---

Originally posted by bhussey

Hello, I am trying to create a query that will query any action changes made within the last 30 days. Let's say someone changes their name, I'd like to pull their current name/record and the previous name/record.

This is the query used to pull the current record
select employee, fld_nbr, date_stamp
from hrhistory
Where fld_nbr = '2'
and date_stamp > (sysdate-30)

---