SQL Count

Results 1 to 2 of 2

Thread: SQL Count

  1. #1
    Join Date
    Dec 1969

    Default SQL Count

    Can anyone tell me how to use the SQL Count(). I am opening multiple tables and joining them and want to know how to count how many items there are in one field. For example:<BR><BR>Select events.title, events.news, photos.address, author.name FROM etc. etc.<BR><BR>I want to know how many photo.address records are in the recordset without a loop that would slow down the server.<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Count

    select<BR> count(photos.address) as PhotoCount<BR>From<BR> photos<BR><BR><BR>if you want a distinct count just do <BR>distinctcount(photos.address)<BR><BR>Think that&#039;s what you are looking for.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts