Subs Query

one variable

WITH myconstants (var1) as (values ('2023-21-01'))

select var1 from myconstants

var1      |

----------+

2023-21-01|

two variable

WITH myconstants (var1,var2) as (values ('2023-21-01','2023-12-31'))

select var1,var2 from myconstants

var1      |var2      |

----------+----------+

2023-21-01|2023-12-31|

one variable using query

WITH myconstants (var1) as

(select max(date) from reference_internalndm_calender_all_date where yearmonth = '202312')

select var1 from myconstants

var1      |

----------+

2023-12-28|