471,853 Members | 1,770 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,853 software developers and data experts.

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 7640
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 NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.