如何比较来自同一表的2行(SQL Server)

I need to create a background job that processes a table looking for rows matching on a particular id with different statuses. It will store the row data in a string to compare the data against a row with a matching id.I need to create a background job that processe