Re: SQL & Counting
2000-02-17 10:52:56
Here's an example of a useful count statement:
Scratch.mac
SELECT LIBVOLUMES.VOLUME_NAME, LIBVOLUMES.STATUS, LIBVOLUMES.LIBRARY_NAME
FROM LIBVOLUMES LIBVOLUMES WHERE (LIBVOLUMES.STATUS='Scratch')
SELECT COUNT(LIBVOLUMES.VOLUME_NAME) as "Scratch volumes" FROM LIBVOLUMES
LIBVOLUMES WHERE (LIBVOLUMES.STATUS='Scratch')
Wes Lewison
Senior Technical Programmer
Winn-Dixie Stores, Inc.
904-783-5939
|
|
|