Re: query for # of rows

From: Doug O'Leary <dkoleary_at_mediaone.net>
Date: Sat, 15 Jan 2000 11:29:57 -0600
Message-ID: <MPG.12ea6a9488c96a9f989714@nntp.ce.mediaone.net>

In article <85p1jr$5lm$1_at_nnrp1.deja.com>, dbrah_at_my-deja.com says...
> Is there a command to query a table for the number of rows without
> having to do SELECT *?

Maybe I'm misunderstanding, but wouldn't

select count(*)
from <table>

do what you're looking for?

Doug

--

---

Douglas K. O'Leary
Senior System Admin
dkoleary_at_mediaone.net

---

Received on Sat Jan 15 2000 - 11:29:57 CST