/SQL/Postgres declare variable

Postgres declare variable

Postgres declare variable

WITH myconstants (var1, var2) as (
   values (5, 'foo')
)
SELECT *
FROM somewhere, myconstants
WHERE something = var1
   OR something_else = var2;

0

Similar codes

2 votes193 views1 answer
Find column in all stored procedures sql server
SQL
0 vote215 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote228 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
0 vote171 views1 answer
Mariadb mysql root access denied
SQL
0 vote171 views1 answer
Psql get table data types
SQL
0 vote179 views1 answer
Sql requete number pair
SQL
0 vote179 views1 answer
Remove transient options sql wordpress
SQL
0 vote169 views1 answer
Dbms_output sql developer
SQL
2 votes165 views2 answers
Exec procedure pl sql
SQL
1 vote181 views1 answer
Oracle drop job if exists
SQL

Share