Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query.
- 8 Answers
- 33114 Views
- Intelenet, I also Faced
- E-Mail Answers
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 |
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,
How to Install SQL SERVER 2005 remotely?
What is the difference between a fill factor of 100 and 0?
whats the maximum size of view state??
How can I track the changes or identify the latest insert-update-delete from a table?
explain databases and sql server databases architecture? : Sql server database administration
How do you trace the traffic hitting a sql server?
Explain how to integrate the ssrs reports in application?
What are different types of statement?
Can we delete data from a view?
What is INTVAL( )and where we use Plz any body help me
Is mysql better than sql server?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
