topsort.sql « lineage « suites « sql « tests « essentials « yql - ydb - Mirror of YDB github repos

about summary refs log tree commit diff stats

path: root/yql/essentials/tests/sql/suites/lineage/topsort.sql

blob: 2289cb02b1a6a536ea344099c0d6821aaae4829b (plain) (blame)

USE plato;

INSERT INTO Output
SELECT a.value
FROM Input AS a
INNER JOIN (SELECT value FROM Input ORDER BY value LIMIT 1) AS b
USING (value);