What is the coverage of WHERE syntax within Salesforce Integration App?

Salesforce has a data table that has data like this.

I would like to import the data from this table according to certain conditions.

The condition is that when the accountid is the same, only one number with the lowest vid fill is brought in.

At this time, I'm going to use Eloqua account import to link sales app,

How should I use the above conditions in the WHERE section?

For your information, I've considered this method (1. groupby 2. subquery 3. left join) I don't think it's composed of only WHERE clause.

Is there any amazing way?