Moving between Rows

• bitsenator

  Newbie

  Points: 9

  More actions

  September 29, 2011 at 9:37 pm

  #258147

  Hi Guys,

  I am a new SQL user and need help with below:

  I have a table like:

  Name-ENG-Science-Total

  A - 1 - 0

  L - 5 - 20

  T - 15 - 82

  Now as you can see that I dont have a unique ID on which I can select a particular row and update it. All I am trying to do is to create a loop to update the Field "Total" to ENG+ Science.

  So when I run the query, it will update as Below:

  Name-ENG-Science-Total

  A - 1 - 0 - 1

  L - 5 - 20 - 25

  T - 15 - 82 - 97

  Please help guys

  Dave

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  September 30, 2011 at 1:56 am

  #1388714

  Homework?

  -- Gianluca Sartori