Please help me in creating a update query
- by Rajesh Rolen- DotNet Developer
I have got a table which contains 5 column and query requirements:
update row no 8 (or id=8) set its column 2, column 3's value
from id 9th column 2, column 3 value.
means all value of column 2, 3 should be shifted to column 2, 3 of upper row (start from row no 8) and value of last row's 2, 3 will be null
For example, with just 3…