on ‎2024 Aug 29 1:18 PM
How to create a calculated column in a database which returns "Unique" if user ID appears once & "Not Unique" if it appears more than once?
I have a database with a list of user IDs. Here, a user ID may be unique or may be repeated. Is there a way I can add a calculated column to my query which returns "Unique" for those user IDs that appear once in the database and "Not Unique" for those user IDs that appear two or more times?
Request clarification before answering.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 6 | |
| 5 | |
| 5 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.