In Progress

Need help creating a simple logic in SQL

I have a table [login to view URL] I need to write a logic to achieve the EXPECTED_TABLE.jpg. I think I need to compare the current value of the ID column with the next value of the ID column to get the sequence numbering just like is shown in column COUNT_SEQ in EXPECTED_TABLE.jpg. I'm not sure how this can be completed in SQL.

Skills: SQL, MySQL, Microsoft SQL Server, Oracle, Database Administration

About the Client:
( 20 reviews ) Worcester, United States

Project ID: #33789596

Awarded to:

ruggd71

Hello! I have checked your description carefully and I am really interested in this job. I have rich experience in SQL and I provide cleaning code. I will do my best with high-quality and meet deadline. Looking forward More

$20 USD in 7 days
(1 Review)
3.2

9 freelancers are bidding on average $21 for this job

ecommercejui

Hi, I understand and I am highly interested to create logic on SQL. I'm an experienced web developer with the necessary skills for getting this job done. I am available to start immediately. I will provide a great res More

$30 USD in 1 day
(12 Reviews)
4.9
KimVadim

Hello, Dear client! I've just read your description and guarantee to complete perfectly your job. I have 7+ years experience in the fields such as your requirement and I am SQL expert. You will get a good result after More

$30 USD in 7 days
(10 Reviews)
4.1
stefanandjelkov1

Hello, I am a SQL Expert. I have read your requirement carefully. I have rich of experiences about Database. I have done some projects like your project lately. You can see my profile so that proof it. I hope to help y More

$30 USD in 7 days
(2 Reviews)
1.8
prasitkeng

I read your requirement and attachments and I strongly believe that this project can be completed within a day. Your project can be completed by using windowing function. Your requirement is what I exactly do every da More

$20 USD in 1 day
(0 Reviews)
0.0
shanejohnson85

Hello. Nice to meet you. I read your job right now and I am very interested in your job. I am a full stack developer with enough experience in web development. For development I used Database for back-end. So I think I More

$20 USD in 1 day
(0 Reviews)
0.0
vilyadd

Hi. Thanks for your posting job. I will provide perfect result within 1 hour. I read your job description and I am very interested in your job. Do you need an expert developer? I think I am a good fit for your job and More

$10 USD in 1 day
(0 Reviews)
0.0
vineetagrawalggc

Hi There, I have checked th images but i think data is not correct in table, is it sample or real data? Let's connect for more discussion Thanks Amit

$20 USD in 7 days
(0 Reviews)
0.0
joaodavidsouza

Hello. Very nice to meet you. I just read your posting and sounds like you need an expert in SQL Development. A bit About me... I have a background in DB Development for 7 years and recently worked on backend with myS More

$10 USD in 1 day
(0 Reviews)
0.0