Certified Marketing Cloud Developer

By Salesforce · Question Mode

QuestionQ113

VerifiedData Modeling and Management

A data extension has two fields that are populated by a query activity. A third field was recently added to the data extension.

Which SELECT statement would be optimal for returning every column in the data extension?

Explanation

SELECT * uses the asterisk as shorthand for all columns in the selected data extension, so it returns the existing fields and the recently added field without duplicating columns or requiring the field list to be maintained.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!