SQL Query

I have a table as below

Material   SeqNum   Controlkey
22             1                  x
22             2                  x
22             3                  x
22             4                  x
24             1                  x
24             2                  x

I have to update controlkey='y' for the max(seqno) for each material. I came up with the query

update Table_3
set ckey='ybp3'
from Table_3
where seqno=(select MAX(seqno)
from Table_3
group by Material)

But this is giving me two values in subquery . Here in the above query I need to update table as

Material   SeqNum   Controlkey
22             1                  x
22             2                  x
22             3                  x
22             4                  y
24             1                  x
24             2                  y


Thanks !
himabindu_nvnAsked:
Who is Participating?
 
fundacionrtsAdministrador de SistemasCommented:
update
      Table_3_update
set
      ckey='ybp3'
from
      Table_3 Table_3_update
where
      seqno=(select MAX(seqno)
                  from Table_3 t3
                  where t3.Material = Table_3_update.Material
                  group by Material)
0
 
himabindu_nvnAuthor Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.