question

Johntl17 avatar image
Johntl17 asked

Removing client IDs from different categories

I’ve built a query with 4 different status: 1. Level 1 2. Level 2 3. Level 3 4. Level 4 I have client IDs which can be in any of the above categories. I’m trying to create sort of a waterfall affect. If a client is in level 1 then I’d like to remove them from any of the other levels. Then moving to level 2, the client Id cannot be in levels 3 and 4 and so forth. Can someone please help me figure out the best way to attempt this? I’d really appreciate it.
subquery
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@Johntl17 Please provide some sample data or elaborate a bit. It is not clear whether the categories are **columns**, so every record with specific client ID has some of the columns' values set to, say, 1, or you have **multiple rows** with the same client ID value and would like to delete the rows based on the logic in your question. Thank you.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.