Hai @Ashok Kumar

Thank you for your response. However, my current approach involves hitting the database every time in order to obtain the desired results. Given that I am unsure of the number of q_ids that will be involved in the future, I am concerned about the performance impact. Therefore, I am exploring alternative approaches to address this issue.

Kindly let me know if there are any other approaches such as stored procedures or minimalistic database hits that can help me achieve my expected outcome.

I realize my previous request may have been confusing. Let me clarify my question.

For the current approach, I need to run the query each time by incrementing the column (queue_id) value. But I'm trying to run the query once, which should dynamically increment the column values. For sample Output I am expected:

Thanks @Vitaliy Serdtsev

It's working as expected.