selecting consecutive records from a table based on a column value

Hi Visakh16

Now I don't get the error cross join(values(0),(1),(2),(3))u(x)

When I run your query it returns more than 4 records. But I need only 4 records.

After selecting those 4 records, I need to update the colc as 'Assigned'.

---

mnmhema