select each ID that have more than 1 item in SQL?

Answer 1

Given two tables (Table1 and Table2), you would count the number elements from the second table and use it in a HAVING clause.

SELECT Table1.ID
FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID
GROUP BY ID
HAVING Count(ForeignValue)>1));