DQL Query

Sanober

Hi Experts,

How can we delete a value from Register Table.

Ex:-

delete from dm_dbo.junction where emp_id=20757

this query deletes the whole record of emp.i just want to delete his profile

i also tried this

delete emp_profile from dm_dbo.junction where emp_id=20757

but it returns error.

DCTM_Guru

What do you mean "his profile"?  If you just want to clear the value of emp_id, but not delete the row, use an UPDATE

Sanober

like

update dm_dbo.junction set emp_profile=' ' where emp_id=20757