select * from table1 where id not in (select id from table1 where status='rework')

first-of-all, u read the question first and give the comments to others.

I feel, u didn't read very well.

the question is

select start_date,* from employee order by start_date desc

from this...

sorry your answer is not correct because both are same table so there is no problem to call the column any where in the select statement please try again the...