I really appreciate if you can share the link with your friends via Facebook,twitter,blog etc.

08 August 2011

Sql Practice - 1


Hi all,
One of my friend have been asked in of the interview following question,

Consider you have at table Say TblEmployee with a column say EmployeeName
which contain Records as A,B,A,A,B,C,B,C,A

your task is to write a query which will change the EmployeeName A to B and B to A.
Means after the query been executed Records will be as B,A,B,B,A,C,A,C,B
.
.
.
.
.
Think what will be the query..and try to post some answers..after two day i will post the answer