homehome previousprevious nextnext
 
Setting Output Fields

The fields you have selected in the graphical view will be displayed in the Syntax View which allows you to set their displaying order and modify the output fields of the query using <distinct>, <func> and <Alias>.

<distinct>
Enable this option if you wish the repeated records are not included into the query result.

<func>
Set the aggregate functions (SUM, MAN, MIX, AVG, COUNT) for each field.

<Alias>
Change the output query field name.


 

 

 

Copyright 1999 - 2007. PremiumSoft TM CyberTech Ltd All rights reserved
MySQL TM is a trademark of MySQL AB in the United States and other countries.