ok,

I want Particular departmant only.Just i copy and pasted this.next time i will post the sample data with proper format.not just for single update statement.It need to verify if that employee belongs to particular department and then update salary when his salary less than thousand else put same.