这里会显示出您选择的修订版和当前版本之间的差别。
两侧同时换到之前的修订记录 前一修订版 | |||
zh:notes:education [2024/06/24 10:04] pzczxs [Extract Simple Cycles] |
zh:notes:education [2024/06/24 10:05] (当前版本) pzczxs [Extract Simple Cycles] |
||
---|---|---|---|
行 207: | 行 207: | ||
> AND a.doi is not null and ca.doi IS NOT NULL AND flag = 0 | > AND a.doi is not null and ca.doi IS NOT NULL AND flag = 0 | ||
> AND ca.journal_id IS NOT NULL | > AND ca.journal_id IS NOT NULL | ||
- | > ORDER BY citing_doi ASC, cited_doi ASC | + | > ORDER BY citing_doi ASC, cited_doi ASC; |
+ | |||
+ | > DELETE FROM citation WHERE citing_doi = cited_doi; | ||
</code> | </code> | ||