Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. SELECT author_obj->>'$.name' FROM author WHERE author_obj->'$.name' NOT IN
  2. (SELECT DISTINCT author_obj->'$.name'
  3. FROM response INNER JOIN author ON response.author_id = author.id
  4. WHERE response.parent IS NOT NULL
  5. GROUP BY author.id);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement