In this article I'm going to explain the use of the analytic functions RANK, DENSE_RANK and ROW_NUMBER to rank the results of your query.
Crop diversification refers to the addition of new crops or cropping systems to agricultural production on a particular farm taking into account the different returns from value-added crops with complementary marketing opportunities. Major driving forces for crop diversification include: â¢ Increasing income on small farm holdings
The introduction of new crop species to diversify the crop production systems needs to take into account the following inter-related categories: Availability and quality of resources including irrigation, rainfall and soil fertility.