nkezhaya · May 16, 2021 17:29
diff --git a/foo.sql b/foo.sql
 WITH RECURSIVE t AS (
   SELECT min(author) AS author FROM posts
   UNION ALL
   SELECT (SELECT min(author) FROM posts WHERE author > t.author)
   FROM t WHERE t.author IS NOT NULL
   )
 SELECT author FROM t WHERE author IS NOT NULL
	WITH RECURSIVE t AS (
	SELECT min(author) AS author FROM posts
	UNION ALL
	SELECT (SELECT min(author) FROM posts WHERE author > t.author)
	FROM t WHERE t.author IS NOT NULL
	)
	SELECT author FROM t WHERE author IS NOT NULL
No results found