Vous êtes un professionnel et vous avez besoin d'une formation ? Mise en oeuvre d'IHM
avec Qt et PySide6 Voir le programme détaillé

Classe « GenerativeSelect »

Méthode sqlalchemy.GenerativeSelect.fetch

Signature de la méthode fetch

def fetch(self, count: '_LimitOffsetType', with_ties: 'bool' = False, percent: 'bool' = False) -> 'Self' 

Description

help(GenerativeSelect.fetch)

Return a new selectable with the given FETCH FIRST criterion
applied.

This is a numeric value which usually renders as ``FETCH {FIRST | NEXT}
[ count ] {ROW | ROWS} {ONLY | WITH TIES}`` expression in the resulting
select. This functionality is is currently implemented for Oracle
Database, PostgreSQL, MSSQL.

Use :meth:`_sql.GenerativeSelect.offset` to specify the offset.

.. note::

   The :meth:`_sql.GenerativeSelect.fetch` method will replace
   any clause applied with :meth:`_sql.GenerativeSelect.limit`.

.. versionadded:: 1.4

:param count: an integer COUNT parameter, or a SQL expression
 that provides an integer result. When ``percent=True`` this will
 represent the percentage of rows to return, not the absolute value.
 Pass ``None`` to reset it.

:param with_ties: When ``True``, the WITH TIES option is used
 to return any additional rows that tie for the last place in the
 result set according to the ``ORDER BY`` clause. The
 ``ORDER BY`` may be mandatory in this case. Defaults to ``False``

:param percent: When ``True``, ``count`` represents the percentage
 of the total number of selected rows to return. Defaults to ``False``

.. seealso::

   :meth:`_sql.GenerativeSelect.limit`

   :meth:`_sql.GenerativeSelect.offset`

Vous êtes un professionnel et vous avez besoin d'une formation ? Coder avec une
Intelligence Artificielle Voir le programme détaillé