MATLAB DATABASE TOOLBOX RELEASE NOTES Guide de l'utilisateur télécharger pdf (Page 323)

100

101

Fine-Tuning Queries Using Advanced Query Options

5-45

For B, results are first sorted by January sales in ascending order. The lowest

value for January sales, 1200 (for item number 400455), appears first. The

highest value, 5000 (for item number for 400345), appears last.

For items 400999, 400314, and 400876, January sales were 3000. Therefore, the

second sort key February salesapplies. February sales appear in ascending order:

1500, 2400, and 2400 respectively.

For items 400314 and 400876, February sales were 2400, so the third sort key,

March sales, applies. March sales appear in descending order: 1800 and 1500,

respectively.

Using Having Clauses to Refine Group by Results

Using the HAVING Clauses Dialog Box

Use the Having function to refine the results of a Group By clause.

After specifying a group-by clause in Advanced query options, click Having. The

HAVING Clauses dialog box appears.

1 2 ... 318 319 320 321 322 323 324 325 326 327 328 ... 683 684

Commentaires sur ces manuels

Pas de commentaire

MATLAB DATABASE TOOLBOX RELEASE NOTES Guide de l'utilisateur Page 323

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel MATLAB DATABASE TOOLBOX RELEASE NOTES