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
For most farmers, a productive farm would also produce more goods than required for the community in order to allow trade. Diversity in agricultural production is one key to productivity, as it enables risk management and preserves potentials for adaptation and change.