On Thursday, November 11, 2021, aditya desai <
admad123@gmail.com> wrote:
" Status as on 11th Nov" should be my column name in a query.
SELECT JoiningDate as "Status as on 11th Nov" from empdetails;
How can I achieve this?
Dynamic SQL and two independent queries. One to get the column name. Then a dynamic one (say using pl/pgsql) that uses that name.
David J.