Timeline for How to normalize data based only on the repetitions
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 19, 2013 at 3:30 | comment | added | Joel Brown | @just.another.programmer: See the edit to my answer. The SQL you're proposing almost right. Use not equal to one since you want to have some relationship, but not multiple relationships. | |
| Feb 19, 2013 at 3:28 | history | edited | Joel Brown | CC BY-SA 3.0 |
Added an answer to a follow-up question from OP.
|
| Feb 18, 2013 at 21:18 | comment | added | just.another.programmer |
If I use select col2 from tbl group by col2 having count(distinct col1) > 1, and get zero rows back, does it mean col2 has a functional dependency on col1?
|
|
| Feb 18, 2013 at 20:32 | vote | accept | just.another.programmer | ||
| Feb 13, 2013 at 12:49 | history | answered | Joel Brown | CC BY-SA 3.0 |