DB Get and select count(*)

Unanswered Question

I need to find out how many records of type X I have in the database.

Since select count(*) is not supported , I was thinking of using something like

SELECT count(distinct(XXX)) from YYY (xxx are unique values)

Is it possible to assign the returned result to a variable and how.

DB Get only seems to be able to get columns values.


I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
gmarogi Fri, 02/23/2007 - 06:24

I am just wondering if the query Select AgentsLoggedOn from Peripheral_Real_Time will give the count.


This Discussion