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
Many of these crops are important regionally. Wheat is the most important crop in the northwest, now the center of Mexicoâs grain production. Other important crops in the northwest are winter vegetables such as tomatoes and lettuce as well as oilseeds.