Updating multiple records in this year with information held in previous year

Question

Hi,

I’m new to SQL and would really appreciate some advice.

I need to update multiple records (student records so they have a unique ID) with data held against the student in a previous year.  So student A had QoE of ‘04’ in 19/20, how do I set the 20/21 QoE field to what it was in 19/20 for all students in one query?

Many Thanks in Advance,

Sarah

Answer 1

Hello,

For your query you can refer this:https://www.plus2net.com/sql_tutorial/sql_update.php

Hope it helps you!!