We help IT Professionals succeed at work.

Get the count from my select statement?

I need simply the COUNT of the following statement:

SELECT       t1.UserID, t1.State, t1.City, t2.Active
FROM          City AS t1 INNER JOIN
                      members AS t2 ON t1.UserID = t2.UserID
WHERE     (t1.State = 'New York') AND (t1.City = 'New York City') AND (t2.Active = 1)


How do I do this?
Comment
Watch Question

Obadiah ChristopherDeveloper User Interface
BRONZE EXPERT

Commented:
select @@Count

Author

Commented:
And how do I "select @@Count?"  

Please build my new statement for me.

Commented:
SELECT COUNT(t1.UserID, t1.State, t1.City, t2.Active)
FROM          City AS t1 INNER JOIN
                      members AS t2 ON t1.UserID = t2.UserID
WHERE     (t1.State = 'New York') AND (t1.City = 'New York City') AND (t2.Active = 1)

Open in new window

Senior Analyst - Technology
BRONZE EXPERT
Commented:
Count takes a single parameter. The correct statement is...

SELECT       Count (*)
FROM          City AS t1 INNER JOIN
                      members AS t2 ON t1.UserID = t2.UserID
WHERE     (t1.State = 'New York') AND (t1.City = 'New York City') AND (t2.Active = 1)

Open in new window

Author

Commented:
yes that worked perfectly

Explore More ContentExplore courses, solutions, and other research materials related to this topic.