How to delete particular value in the column of a table.Is it possible or not?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query.

Question Posted / vanitha.s

8 Answers
32876 Views
Intelenet, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to delete particular value in the column of a table.Is it possible or not?if possible give it ..

Answer / rupa bagherwal

You can not exactly delete the column value.
alternatively what you can do is use update statment and
update the value with blank.

update users
set user_adr = ''
where user_id = 'userid'

Is This Answer Correct ?

96 Yes

12 No

How to delete particular value in the column of a table.Is it possible or not?if possible give it ..

Answer / subramaniam

Rupa Bagherwal is told the answer is correct
we cant delete particular value in one column
we can update onle

delete from employee where employeeid=2

suppose we wil give like this means it will delete one row

for this questions update only possible

Is This Answer Correct ?

31 Yes

7 No

How to delete particular value in the column of a table.Is it possible or not?if possible give it ..

Answer / nilesh

Update tablename set Column_name = '' where f_name = 'student'

Is This Answer Correct ?

17 Yes

7 No

How to delete particular value in the column of a table.Is it possible or not?if possible give it ..

Answer / nadeer

we can't delete a particular value of column,
instead of this we can make that column value as
blankspace,or u can rewrite a values on it by "update emp
set id=5555 where id=4444;

Is This Answer Correct ?

9 Yes

3 No

How to delete particular value in the column of a table.Is it possible or not?if possible give it ..

Answer / krish

DELETE FROM tablenameWHERE columnname AND columnname

Is This Answer Correct ?

1 Yes

2 No

How to delete particular value in the column of a table.Is it possible or not?if possible give it ..

Answer / sunil kumar basuru

we cant delete the particular column because oracle two
dimensional structure.but instead of delete we can do column
'null'

Is This Answer Correct ?

2 Yes

5 No

How to delete particular value in the column of a table.Is it possible or not?if possible give it ..

Answer / elumalai.k

delete from tablename where columnname=datatype
examples:
delete from employee where employeeid=2

Is This Answer Correct ?

13 Yes

71 No

How to delete particular value in the column of a table.Is it possible or not?if possible give it ..

Answer / suresh.s

Example:
Delete from STUDENTDETAILS where StudentID = 101

Is This Answer Correct ?

20 Yes

82 No

Post New Answer