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

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

More SQL Server Interview Questions

Explain timestamp datatype?

0 Answers  


How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,


what is call by value & call by reference ?

2 Answers   Cap Gemini,


how can you check the level of fragmentation on a table? : Sql server administration

0 Answers  


What is implicit mode in sql server?

0 Answers  


What do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  


What is the difference between a stored procedure and a user defined function in sql server?

2 Answers   Millennium,


i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  


what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

0 Answers  


Difference between group by clause and having clause in SQL?

0 Answers   Flextronics,


Explain foreign key in sql server?

0 Answers  


Where sql server user names and passwords are stored in sql server? : sql server database administration

0 Answers  


Categories