Ehsan Ullah
IT Analyst
Home
New *
Home
Experience
Current Projects
Portfolio
Education
Contact Me
About Me
Time Line
SQL Updating ID with Row Number
with toupdate as (
select t.*, row_number() over (partition by Employee_ID order by DOH) as seqnum
from Employee_Immunizations t
)
update toupdate
set ID = seqnum;
Newer Post
Older Post
Home