SPQuery Class enables query against SharePoint lists. The Where clause can be assigned to Query property in Collaborative Application Markup Language (CAML) representation. Columns to return by the query can be controlled by ViewFields property. Number of rows to return by the query can be controlled by RowLimit property. Also, these properties can be directly added in XML format to ViewXML property.