Sql select problem

Hello,

The following is the data that I need to model in sql :

runcntl          OPRID      EMPLID       cntrct    DEPTID              
TEST               L             2001548      148137      8437             
TEST               L              2001548 148137      8500             
TEST             L               2001548 148139      8450             
TEST            L             2001548      148139      8460             
TEST            L               4086876      148140      8370             
TEST            L               4088876  148151      8370             
TESTS            L               4088876      148152      8370             
TEST           L              9700994 148150      8360             
TEST           L             9700994      148150      8370             
TEST           L             4086876      148152      8370             


I do not want  the values below to appear in the result

TEST   L      4088876      148151      8370
TEST   L      4088876      148152      8370
TEST   L      4086876      148152      8370


So I only want the EMPLID who have different deptids either within a single cntrct or across multiple cntrcts.

Can this be done without a CTE?

Thanks, Brock