MySQL Forums
Forum List  »  Newbie

Marking a Table
Posted by: Michael Smith
Date: June 05, 2023 07:53PM

I have a table where there are about 100 groups. Each group has about 5 rows.

The group field is 'INVOICENO'.

Some of the groups have the first item of the group marked with GMARK = "X".

I would like to write code where each group that has the first item as GMARK = "X" would have GMARK2 marked as "X" for all rows with that INVOICENO.

If any have suggestions I would be please to hear from you.


Options: ReplyQuote

Written By
Marking a Table
June 05, 2023 07:53PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.