By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,795 Members | 1,242 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,795 IT Pros & Developers. It's quick & easy.

How to count number of rows

P: n/a
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
Share this Question
Share on Google+
1 Reply

P: n/a
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.