[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
SQL Count Statement
Can you include an SQL count statement in your SQR without having any
other columns being selected?
Begin-SQL
Select count (emplid) from ps_employees
where empl_status in ('A','L')
order by paygroup
End-SQL
Susannah Wells
Software Engineer
Paging Network, Inc.
Work 972-985-6352
VoiceNow 972-330-3898
Pager 214-835-9638, Dallas Pin 0 005-3565
Internet susannah_wells@pagenet.com