Advertisements
In sql server we can create new column by adding some value like below
select *, new_column = fixed_value from table
samething I want to replicate in Databricks Sql , but in databrick getting error new_column is not present. How to do this in Databrick for temp table
>Solution :
in databricks you use aliases, which you also can use in sql server and other rdms
select *, 1 as new_column from table