New answers tagged table
1
vote
Accepted
Getting all shared values of two or more given values in one table (SQL)
Based on the data and expected result I think you are looking for MySQL HAVING clause.
Your data:
CREATE TABLE test(
uid INT,
cid int );
insert into test values (1,1), (2,1),(3,1),(2,2),(3,2);
...
Top 50 recent answers are included
Related Tags
table × 501mysql × 155
database-design × 117
sql-server × 106
postgresql × 51
oracle × 39
join × 21
update × 20
schema × 18
partitioning × 17
query × 16
foreign-key × 15
index × 14
performance × 11
trigger × 11
mariadb × 10
mysql-5.6 × 10
select × 10
insert × 10
view × 10
erd × 10
sql-server-2012 × 9
sql-server-2008-r2 × 9
t-sql × 9
innodb × 9