Home Posts tagged "sql"

Delete first two rows for each Sourcer

SELECT * FROM report WHERE “Req Status” = ‘hc-placed’ ORDER BY “Sourcer”, kickoff_date ASC I have this query that pulls job placement data and orders by the sourcer (username) and job kickoff dates. I would like to remove the first two rows from EACH sourcer (oldest two jobs which are already sorted by kickoff date).

Read More