LoginSignup
2
1

More than 5 years have passed since last update.

@kazuki-ma(Kazuki MATSUDA)

Presto DB で DUAL 表が欲しい

Posted at

DUAL Table

The synthetic DUAL table is no longer supported. As an alternative, please write your queries without a FROM clause or use the VALUES syntax.

昔はあったんかい

FROM DUAL の代わりに

SELECT date '2012-08-08' + interval '2' day
FROM (VALUES 1) AS DUAL("")

これでいける

FROM 句がそもそも要らない場合は

VALUES date '2012-08-08' + interval '2' day
2
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
2
1