469,148 Members | 1,409 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,148 developers. It's quick & easy.

How to count number of rows

Hello, Dean
Try this:

select distinct c1, c2 into #tmp_1 from t1
select count(*) as cnt from #tmp_1
drop table #tmp_1

With best regards.
Jul 20 '05 #1
1 7547
how to count number of rows?

well, try this....

select count(*)
from <yourtable>
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by John Furphy | last post: by
22 posts views Thread by Joseph Shraibman | last post: by
5 posts views Thread by Daniel Wetzler | last post: by
68 posts views Thread by Martin Joergensen | last post: by
5 posts views Thread by Stephen | last post: by
2 posts views Thread by John | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.