This is a sample code for retrieving top 5 items from the SharePoint List.
SPQuery is the SharePoint class to initialize the CAML query.
This following Query will display the top 5 items OrderBy ID as Ascending is false.
using (SPSite objSite = new SPSite("<Site URL>"))
{
using (SPWeb objWeb = objSite.OpenWeb())
{
SPList spList = objWeb.GetList("<List URL>");
SPQuery spQuery = new SPQuery();
spQuery.Query = "<Query>
<OrderBy>
<FieldRef Name='ID' Ascending='False' />
</OrderBy> </Query> ";
spQuery.RowLimit = 5;
SPListItemCollection spListItemCollection = spList.GetItems(spQuery);
}
}