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
- 32867 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 retrieve field names from the table in SQL through JAVA code?
Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0
7 Answers PMAM IT Services, TCS,
Are semicolons required at the end of sql statements in sql server 2005?
Explain transaction server consistency?
What happens if you delete a table that is used by a view?
What is difference between getdate and sysdatetime in sql server 2008?
Can sql servers linked to other servers like oracle?
how to find number of columns in a table in sql server 2000 and 2005 also
What happens if null values are involved in arithmetic operations?
A trigger can reference objects outside the current database? State true or false.
What does select 1 mean?
how to define testing of network layers? : Sql server database administration
-
Oracle (3259) - 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)
