[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: SQL Count Statement

You can select a single count statement in a select statement
be careful of your syntax though

BEGIN-SELECT
count(emplid)
FROM ps_employees
   WHERE empl_status in ('A','L')
   ORDER BY paygroup
END-SELECT

------------------
Aaron Solomon
Programmer/Analyst
Goldman Sachs
(212) 902-9094
------------------

--
----------------------------------------------------------------
 #####   #####           #####  ####### #     # Aaron Solomon
#     # #     #         #     # #     # ##   ## (212)902-2222
#       #               #       #     # # # # #
#  ####  #####          #       #     # #  #  # 1 New York Plaza
#     #       #   ###   #       #     # #     # 44th Floor
#     # #     #   ###   #     # #     # #     # New York, NY
 #####   #####    ###    #####  ####### #     # 10004
----------------------------------------------------------------