home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1993 #3 / NN_1993_3.iso / spool / comp / database / 9309 < prev    next >
Encoding:
Text File  |  1993-01-22  |  1.2 KB  |  33 lines
  1. Newsgroups: comp.databases
  2. Path: sparky!uunet!psinntp!isc-newsserver!ultb!kxs5829
  3. From: kxs5829@ultb.isc.rit.edu (K.X. Saunders)
  4. Subject: Re: Counting Null Values in an SQL Query
  5. Message-ID: <1993Jan22.131533.20160@ultb.isc.rit.edu>
  6. Keywords: I am a Beginner
  7. Sender: news@ultb.isc.rit.edu (USENET News System)
  8. Nntp-Posting-Host: ultb-gw.isc.rit.edu
  9. Organization: Rochester Institute of Technology
  10. References: <1993Jan20.233912.13272@mnemosyne.cs.du.edu>
  11. Date: Fri, 22 Jan 1993 13:15:33 GMT
  12. Lines: 19
  13.  
  14. In article <1993Jan20.233912.13272@mnemosyne.cs.du.edu> afadel@nyx.cs.du.edu (Ayman Fadel) writes:
  15. <The problem is I'm also supposed to count the
  16. <number of patients in each unit form whom no
  17. <value of acuity was entered, ie. level is null.
  18. <
  19. <Everything is good except that I cannot get a count for the
  20. <number of patients without an acuity.
  21. <
  22. <Any help?
  23.  
  24.     Instead of count(level), try count(*).
  25.  
  26.     - Kyle
  27.  
  28. -- 
  29. _,--\_/>>    kxs5829@ultb.isc.rit.edu                   // Amiga weenie        
  30. `"""-(_-\    kyle@nick.csh.rit.edu                  \\ //                     
  31.   _,// \_\                                           \X/                      
  32. *""'     "" not representing Phoenix Systems Inc.                             
  33.