Do a first quesrt using sql count
On Jan 26, 2013 12:41 PM, Rick Faircloth r...@whitestonemedia.com wrote:
If I'm running a query on a database
and limit the records returned to 10,
what's the best way to get the record count
for the entire dataset if everything was
return and not just the
Something like this perhaps?
SELECThelp_topic_id , (SELECT count(help_topic_id) FROM
mysql.help_relation ) as IDCount,help_keyword_id FROM
mysql.help_relation
LIMIT 10;
On Sat, Jan 26, 2013 at 12:41 PM, Rick Faircloth
r...@whitestonemedia.comwrote:
If I'm running a query on a database
That worked! Learn something new every day!
Thanks, Gerald and Brian for the tips!
Rick
-Original Message-
From: Gerald Guido [mailto:gerald.gu...@gmail.com]
Sent: Saturday, January 26, 2013 5:45 PM
To: cf-talk
Subject: Re: Getting Record Count
Something like this perhaps
3 matches
Mail list logo