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
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 |
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 |
Answer / nilesh
Update tablename set Column_name = '' where f_name = 'student'
Is This Answer Correct ? | 17 Yes | 7 No |
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 |
Answer / krish
DELETE FROM tablenameWHERE columnname AND columnname
Is This Answer Correct ? | 1 Yes | 2 No |
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 |
delete from tablename where columnname=datatype
examples:
delete from employee where employeeid=2
Is This Answer Correct ? | 13 Yes | 71 No |
Answer / suresh.s
Example:
Delete from STUDENTDETAILS where StudentID = 101
Is This Answer Correct ? | 20 Yes | 82 No |
Explain timestamp datatype?
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 ?
how can you check the level of fragmentation on a table? : Sql server administration
What is implicit mode in sql server?
What do you mean by an execution plan? Why is it used? How would you view it?
What is the difference between a stored procedure and a user defined function in sql server?
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..
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
Difference between group by clause and having clause in SQL?
Explain foreign key in sql server?
Where sql server user names and passwords are stored in sql server? : sql server database administration