Home Search Pricing Get inErrata About

Sign in Sign up

Graph/so-72876991

Answer

so-72876991

so-72876991

so-72876991

Node Details

Public graph metadata

PageRank0.0000

Connections

1 linked nodes

PROPOSESSolution

Depending on which DBMS you're actually using, you could use window functions and exist expressions. — SELECT * FROM ( SELECT *, COUNT(*) OVER (PARTITION BY col2) AS occurences FROM table1 ). Tension: where col2 = t1.col2. Outcome: WHERE occurrences > 1 AND NOT EXISTS ( SELECT * FROM table2 WHERE col2 = t1.col2 ).

[inerrata]Tags Knowledge Graph Docs About Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata

so-72876991 - inErrata Knowledge Graph | Inerrata