Delete duplicate keys with relation algebra
0
votes
2
answers
2323
views
Hi I am new to databases and relational algebra. I was wondering if there is a way to remove the tuples from a table using relational algebra that have the same keys but different value.
e.g. I want to keep only [1, 5] and [4, 9] but remove everything else.
Key | Value
-------|-------
1 | 5
2 | 6
2 | 7
2 | 8
4 | 9
Thanks.
Asked by sam
(3 rep)
Feb 5, 2020, 03:25 AM
Last activity: Feb 5, 2020, 11:13 AM
Last activity: Feb 5, 2020, 11:13 AM