What is the Views 3 equivalent of the MySQL Limit 1 in order to return just the latest record
To get the query in your question you would use a pager:


Select 'Use pager' in the admin UI
Select 'Display a specified number of items'
Click 'Apply'
Enter '1' for "Items per page" on the settings screen.
Save


I suspect you might be talking more about grouping, though, and that the SQL you've got isn't representative of the query you actually want to run.

If that's the case, you should be able to accomplish what you need buy turning on aggregation, and then setting appropriate values for each field's grouping options.