|
|
The features on this page require a GENESIS64 Advanced license and are not available with GENESIS64 Basic SCADA . |
|
|
The features on this page require a GENESIS64 Advanced license and are not available with GENESIS64 Basic SCADA . |
The TOP keyword limits the number of rows returned by a query to a specified number of rows. Percentages are not supported by AnalytiX-BI. The following example retrieves the top 10 products with highest unit price.
SELECT TOP 10 * FROM Products
ORDER BY UnitPrice DESC