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
Staple agriculture puts all of a region's economic eggs in one basket, in contrast to a diversified economy. When prices for the staple crop are low, or supplies diminished by a bad growing season, the entire region can suffer heavily.