Nonstop Database, HiRDB Version 9 UAP Development Guide
Shown below are examples in which a count of the total number of products whose price (PRICE) is $50.00 or more is obtained from the stock table (STOCK), along with the product names of these products (PNAME), and then the resulting list of products is sorted by quantity (SQUANTITY).
SELECT COUNT(*) FROM STOCK WHERE PRICE>=5000 SELECT PNAME FROM STOCK WHERE PRICE>=5000 ORDER BY SQUANTITY
SELECT COUNT(*) OVER(), PNAME FROM STOCK WHERE PRICE>=5000 ORDER BY SQUANTITY
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.