Select "count" result on ONE line

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: rewh2oman <rewh2oman@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 2 Apr 2008 11:21:00 -0700

I'm doing a "select count(*) from table_name" via ODBC. How can I get the
answer to be displayed in ONE line?

ex. select count(*) total_count from table_name

total_count
22

I need that "22" on the same line as the literal "total_count".

How can I do that? Thanks in advance!
.

Follow-Ups:
- Re: Select "count" result on ONE line
  - From: Russell Fields

Prev by Date: ODBC error code 126 Setting up a System DSN
Next by Date: Re: Select "count" result on ONE line
Previous by thread: ODBC error code 126 Setting up a System DSN
Next by thread: Re: Select "count" result on ONE line
Index(es):
- Date
- Thread