> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# query_one

<div className="kinetica-pydoc">
  <div className="dl py method">
    <div className="dt sig sig-object py" id="gpudb.GPUdb.query_one"> <span className="sig-name descname"><span className="pre">query\_one</span></span><span className="sig-paren">(</span><span className="em sig-param"><span className="n"><span className="pre">sql</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">sql\_params</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">\[]</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">sql\_opts</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">{"{"}{"}"}</span></span></span><span className="sig-paren">)</span><a href="https://github.com/kineticadb/kinetica-api-python/blob/master/gpudb/gpudb.py#L11445"><span className="viewcode-link"><span className="pre">\[source]</span></span></a></div>

    <div className="dd">
      <p>Execute a SQL query that returns only one row.</p>
      <p><strong>Parameters</strong></p>

      <div className="blockquote">
        <div>
          <div className="dl simple">
            <div className="dt">sql (<span className="em">str</span>) –</div>

            <div className="dd">
              <p>The SQL query to run</p>
            </div>

            <div className="dt">sql\_params (<span className="em">list of native types</span>) –</div>

            <div className="dd">
              <p>The SQL parameters that will be substituted for tokens (e.g. $1 $2)</p>
            </div>

            <div className="dt">sql\_opts (<span className="em">dict</span>) –</div>

            <div className="dd">
              <p>The options for SQL execution, matching the options passed to <a className="reference internal" href="#gpudb.GPUdb.execute_sql" title="gpudb.GPUdb.execute_sql"><code className="xref py py-meth docutils literal notranslate"><span className="pre">GPUdb.execute\_sql()</span></code></a>. Defaults to None.</p>
            </div>
          </div>
        </div>
      </div>

      <p><strong>Returns</strong></p>

      <div className="blockquote">
        <div>
          <p>The returned row or None.</p>
        </div>
      </div>
    </div>
  </div>
</div>