ids.sql « query « test « sql « dbstore - cvez - Unnamed repository; edit this file 'description' to name the repository.

about summary refs log tree commit diff

path: root/dbstore/sql/test/query/ids.sql

blob: ddc2bf299edd7433956b68b06378a95259fca0e1 (plain)

WITH ids(id, sort) AS (
  VALUES ('foo', 1), ('bar', 2), ('baz', 3)
)

SELECT id
  FROM ids
 ORDER BY sort;