Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

row_number equivalent MS Access for sequential id By Group (2)

select g.CODE
     , count(*)-1 as C_NO
     , g.NAME
from MyTable as g
  left join MyTable as o
    on g.CODE = o.CODE
      and g.NAME >= o.NAME
group by g.CODE
       , g.NAME;
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #equivalent #MS #Access #sequential #id #By #Group
ADD COMMENT
Topic
Name
2+7 =