SQL query for co-citation

[rafetirmak]

1) I have data that represent citing and cited scholar articles
Source Target
Article ID Article ID


2) I need to identify articles that cite two or more article (co-citation coupling)

3) You can find a figure that represents the problem
http://advances.sciencemag.org/conte...600&carousel=1


4) I could not succeed to develop a proper query

5) Does anyone have a working suggestion

[orange]

I approved your post so others could see it and respond.
Many will not download from sites other than the forum.

[ArviLaanemets]

You need a table, where all citations in any article are registred. E.g.
tblArticles: ArticleID, ...;
tblCitations: CitationID, ArticleID, CitatedArticleID, ...

The query

SELECT ArticleID, COUNT(CitatedArticle) AS CitationsCnt FROM tblCitations GROUP BY ArticleID HAVING COUNT(CitatedArticle) > 1

returns the list of articles which have more than 1 citations.