I have a All India Village tab file(6Lac records) and an excel which has information on most of those villages(4Lac records).
I want to select 100 villages from a particular state whose area is the highest.
But in this query the Area is sorted after selecting first 100 records. I want to select 100 records which have the highest area.
Is there a way the villages are ordered first as per the area and then the selection is carried out?