AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Ayuda / Editores / Editor de consultas / Operaciones en consultas
  • Overview
  • How to?
  • Adding an operation into the current Select query
  • Deleting an operation from the current Select query
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Overview
The following paragraphs present:
  • the addition of an operation into a Select query.
  • the deletion of an operation from a Select query.
How to?

Adding an operation into the current Select query

To add an operation into the current select query:
  1. On the "Query" tab, in the "Edit" group, click "Description". The query description window appears.
  2. In the middle section, select the item on which an operation must be performed.
  3. To calculate:
    • the sum of the values in the item, click on "Sum...".
    • the average of the values in the item, click on "Average, Max, Min" and select "Average".
    • the maximum value of the values in the item, click on "Average, Max, Min" and select "Maximum".
    • the minimum value of the values in the item, click on "Average, Max, Min" and select "Minimum".
  4. An item corresponding to the requested calculation is automatically added to the query items.
  5. Validate. The operation is automatically added into the query.

Deleting an operation from the current Select query

To delete an operation from the current Select query:
  1. On the "Query" tab, in the "Edit" group, click "Description". The query description window appears.
  2. In the middle section, select the calculation item to delete.
  3. Press the Del key.
Versión mínima requerida
  • Versión 9
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 26/05/2022

Señalar un error o enviar una sugerencia | Ayuda local