I need to do a case select or something similar to add a field to an order. I was thinking another method maybe a union using a where clasue to select repeating order numbers. The first with the order number must have 'N' for the CONTINUED field. The 2nd row on with the same order number must have a 'Y'. How can make a case select or where clause to determine rpeating order numbers?
case when "When the orderid repeats" then 'Y' else 'N' end as CONTINUED,
order by orderid