SQL updating a column in a table

Posted by tecnodude on Stack Overflow See other posts from Stack Overflow or by tecnodude
Published on 2010-03-12T08:33:11Z Indexed on 2010/03/12 8:37 UTC
Read the original article Hit count: 125

Filed under:
|
|

Hi,

I have the following table in an access database

id  VisitNo     Weight      
1   1           100
1   2           95
1   3           96
1   4           94
1   5           93

Now row 2 and 4 are deleted. So i have...

id  VisitNo     Weight      
1   1           100
1   3           96
1   5           93

However what i need is...

id  VisitNo     Weight      
1   1           100
1   2           96
1   3           93

What is the SQL query i need to accomplish the above?

thanks

© Stack Overflow or respective owner

Related posts about sql

Related posts about query