Skip to main content
Salesforce

Return to Question

clarifying question a bit more
Source Link
Matthew Whittemore
Matthew Whittemore
  • 185
  • 2
  • 6

I need select the Email off the most recently created Contact for all of my Accounts to export via the Data Loader. So far I have this but then I'm stuck. I keep thinking of functions like MAX(CreatedDate) but how the might help me just isn't turning on a light bulb, any ideas?

SELECT Email from Contact where Account in (Select Id from Account) Order By CreatedDate

I need select the Email off the most recently created Contact for all of my Accounts. So far I have this but then I'm stuck. I keep thinking of functions like MAX(CreatedDate) but how the might help me just isn't turning on a light bulb, any ideas?

SELECT Email from Contact where Account in (Select Id from Account) Order By CreatedDate

I need select the Email off the most recently created Contact for all of my Accounts to export via the Data Loader. So far I have this but then I'm stuck. I keep thinking of functions like MAX(CreatedDate) but how the might help me just isn't turning on a light bulb, any ideas?

SELECT Email from Contact where Account in (Select Id from Account) Order By CreatedDate
Tweeted twitter.com/#!/StackSalesforce/status/266400934505107456
Source Link
Matthew Whittemore
Matthew Whittemore
  • 185
  • 2
  • 6

SOQL: Get Most Recent Child of Parent

I need select the Email off the most recently created Contact for all of my Accounts. So far I have this but then I'm stuck. I keep thinking of functions like MAX(CreatedDate) but how the might help me just isn't turning on a light bulb, any ideas?

SELECT Email from Contact where Account in (Select Id from Account) Order By CreatedDate