You need to sign in to do that
Don't have an account?

how to Alias a column in SOQL
Hi Devs,
How do we something simple like below in SOQL.
SELECT ID as ROW_NATURAL_ID FROM ACCOUNT;
Regards,
Nandika
How do we something simple like below in SOQL.
SELECT ID as ROW_NATURAL_ID FROM ACCOUNT;
Regards,
Nandika
you can't create alisa on field, in salesforce it is allow only with the aggregate function. like below
In above it will create default alias expr0 to total.
Thanks, Vikas
The one exception is for queries that use aggregations, like SELECT COUNT(Id) recordCount FROM Account allows you to alias the result of the aggregation from it's default expr0 to recordCount.
So we have to change all our code downstream whenever we make a change to underlying data structure?