# C1.DataConnector.SelectStatement

## Content

<div class="doc-site-dotnet-api-container">



  <h1 id="C1_DataConnector_SelectStatement" data-uid="C1.DataConnector.SelectStatement" class="text-break">SelectStatement Class
</h1>
  <div class="markdown level0 summary"><p>A class representing a SQL select statement</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <div class="inheritance">
    <h5>Inheritance</h5>
    <div class="level0"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></div>
    <div class="level1"><span class="xref">SelectStatement</span></div>
  </div>
  <div class="implements">
    <h5>Implements</h5>
    <div><a class="xref" href="C1.DataConnector.ISQLStatement.html">ISQLStatement</a></div>
  </div>
  <h6><strong>Namespace</strong>: <a class="xref" href="C1.DataConnector.html">C1.DataConnector</a></h6>
  <h6><strong>Assembly</strong>: C1.DataConnector.dll</h6>
  <h5 id="C1_DataConnector_SelectStatement_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public class SelectStatement : ISQLStatement</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Class SelectStatement
    Implements ISQLStatement</code></pre>
  </div>
  <h3 id="constructors">Constructors
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_DataConnector_SelectStatement__ctor" data-uid="C1.DataConnector.SelectStatement.#ctor">
          <a class="xref" href="C1.DataConnector.SelectStatement.-ctor.html#C1_DataConnector_SelectStatement__ctor">SelectStatement()</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
    </tbody>
  </table>
  <h3 id="properties">Properties
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_DataConnector_SelectStatement_Columns" data-uid="C1.DataConnector.SelectStatement.Columns">
          <a class="xref" href="C1.DataConnector.SelectStatement.Columns.html#C1_DataConnector_SelectStatement_Columns">Columns</a>
        </td>
        <td class="markdown level1 summary"><p>An IList of the selected columns represented as ColumnExpression</p>
</td>
      </tr>
      <tr>
        <td id="C1_DataConnector_SelectStatement_CompoundStatements" data-uid="C1.DataConnector.SelectStatement.CompoundStatements">
          <a class="xref" href="C1.DataConnector.SelectStatement.CompoundStatements.html#C1_DataConnector_SelectStatement_CompoundStatements">CompoundStatements</a>
        </td>
        <td class="markdown level1 summary"><p>An IList containing the compound select statements</p>
</td>
      </tr>
      <tr>
        <td id="C1_DataConnector_SelectStatement_Groupby" data-uid="C1.DataConnector.SelectStatement.Groupby">
          <a class="xref" href="C1.DataConnector.SelectStatement.Groupby.html#C1_DataConnector_SelectStatement_Groupby">Groupby</a>
        </td>
        <td class="markdown level1 summary"><p>The Group-by clause of this select statement</p>
</td>
      </tr>
      <tr>
        <td id="C1_DataConnector_SelectStatement_IsCompound" data-uid="C1.DataConnector.SelectStatement.IsCompound">
          <a class="xref" href="C1.DataConnector.SelectStatement.IsCompound.html#C1_DataConnector_SelectStatement_IsCompound">IsCompound</a>
        </td>
        <td class="markdown level1 summary"><p>Boolean to check whether or not this select statement is a compound select statement</p>
</td>
      </tr>
      <tr>
        <td id="C1_DataConnector_SelectStatement_IsDistinct" data-uid="C1.DataConnector.SelectStatement.IsDistinct">
          <a class="xref" href="C1.DataConnector.SelectStatement.IsDistinct.html#C1_DataConnector_SelectStatement_IsDistinct">IsDistinct</a>
        </td>
        <td class="markdown level1 summary"><p>IsDistinct</p>
</td>
      </tr>
      <tr>
        <td id="C1_DataConnector_SelectStatement_IsJoin" data-uid="C1.DataConnector.SelectStatement.IsJoin">
          <a class="xref" href="C1.DataConnector.SelectStatement.IsJoin.html#C1_DataConnector_SelectStatement_IsJoin">IsJoin</a>
        </td>
        <td class="markdown level1 summary"><p>Boolean to check if this SelectStatement contains join tables</p>
</td>
      </tr>
      <tr>
        <td id="C1_DataConnector_SelectStatement_JoinTables" data-uid="C1.DataConnector.SelectStatement.JoinTables">
          <a class="xref" href="C1.DataConnector.SelectStatement.JoinTables.html#C1_DataConnector_SelectStatement_JoinTables">JoinTables</a>
        </td>
        <td class="markdown level1 summary"><p>The list of the tables that are used as Join tables</p>
</td>
      </tr>
      <tr>
        <td id="C1_DataConnector_SelectStatement_Limit" data-uid="C1.DataConnector.SelectStatement.Limit">
          <a class="xref" href="C1.DataConnector.SelectStatement.Limit.html#C1_DataConnector_SelectStatement_Limit">Limit</a>
        </td>
        <td class="markdown level1 summary"><p>The Limit expressed for this SelectStatement</p>
</td>
      </tr>
      <tr>
        <td id="C1_DataConnector_SelectStatement_Offset" data-uid="C1.DataConnector.SelectStatement.Offset">
          <a class="xref" href="C1.DataConnector.SelectStatement.Offset.html#C1_DataConnector_SelectStatement_Offset">Offset</a>
        </td>
        <td class="markdown level1 summary"><p>The Offset expressed for this SelectStatement</p>
</td>
      </tr>
      <tr>
        <td id="C1_DataConnector_SelectStatement_Orderby" data-uid="C1.DataConnector.SelectStatement.Orderby">
          <a class="xref" href="C1.DataConnector.SelectStatement.Orderby.html#C1_DataConnector_SelectStatement_Orderby">Orderby</a>
        </td>
        <td class="markdown level1 summary"><p>The Order-by clause of this select statement</p>
</td>
      </tr>
      <tr>
        <td id="C1_DataConnector_SelectStatement_TableOrSubquery" data-uid="C1.DataConnector.SelectStatement.TableOrSubquery">
          <a class="xref" href="C1.DataConnector.SelectStatement.TableOrSubquery.html#C1_DataConnector_SelectStatement_TableOrSubquery">TableOrSubquery</a>
        </td>
        <td class="markdown level1 summary"><p>The table or the sub-query that appears as the source table for this query(SQL FROM clause)</p>
</td>
      </tr>
      <tr>
        <td id="C1_DataConnector_SelectStatement_Top" data-uid="C1.DataConnector.SelectStatement.Top">
          <a class="xref" href="C1.DataConnector.SelectStatement.Top.html#C1_DataConnector_SelectStatement_Top">Top</a>
        </td>
        <td class="markdown level1 summary"><p>Top</p>
</td>
      </tr>
      <tr>
        <td id="C1_DataConnector_SelectStatement_Type" data-uid="C1.DataConnector.SelectStatement.Type">
          <a class="xref" href="C1.DataConnector.SelectStatement.Type.html#C1_DataConnector_SelectStatement_Type">Type</a>
        </td>
        <td class="markdown level1 summary"><p>The type of the SQL statement</p>
</td>
      </tr>
      <tr>
        <td id="C1_DataConnector_SelectStatement_Where" data-uid="C1.DataConnector.SelectStatement.Where">
          <a class="xref" href="C1.DataConnector.SelectStatement.Where.html#C1_DataConnector_SelectStatement_Where">Where</a>
        </td>
        <td class="markdown level1 summary"><p>The Where clause of this select statement</p>
</td>
      </tr>
    </tbody>
  </table>

</div>