Re: how to return number of rows in a table

From: buckeye714 <buckeye234NObuSPAM_at_zdnetmail.com.invalid>
Date: 2000/07/25
Message-ID: <13ceade9.1079f18d@usw-ex0106-045.remarq.com>#1/1

If you just want a printable sql statement that counts the number of rows in the table try something like this:

select 'There are '||count(*)||' items in the foobar table' from foobar;

the output will look this;

'THEREARE'||COUNT(*)||'ITEMSINTHEFOOBARTABLE'

---

There are 36176 items in the foobar table

(Of course, you will want to turn headings off)

---

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Tue Jul 25 2000 - 00:00:00 CDT