July 10, 2013

SQL Question


Suppose in a table we have 1 column
now column1 has values 
a
b
a
b
a
b

Table name : Table1
Column Name : Column1

Question : update table1 where 'a' should be replaced with 'b'  and 'a' should be replaced with 'd'