Need help with SQL Select Count statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

APanian - 07 Mar 2008 14:32 GMT

I want to pull records from a "Column" within a "Table". I recall in the
past doing a:

SELECT COUNT "n" FROM .... (This is where I am lost!).

I am hoping to pull the contents of the column in a table.

Thanks

Signature

A. Panian
Systems Engineer
Boston, MA

Reply to this Message

DXC - 07 Mar 2008 15:12 GMT

Isn't column count same as the table count ? Do,

Select count(*) from MyTable

If you need the count of the specific values in that column, then do,

Select count(*) from MyTable where Col1 = 'value'

> I want to pull records from a "Column" within a "Table". I recall in the
> past doing a:
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

DXC - 07 Mar 2008 15:33 GMT

If you want to insert it into a table:

For only the count as number:

select count(*) AS TheCount Into table1 from MyTable

For the contents of the column:

select Col1 as MYCol1 Into table2 from MyTable

> Isn't column count same as the table count ? Do,
>
[quoted text clipped - 12 lines]
> >
> > Thanks

Reply to this Message

Tom W - 10 Mar 2008 12:58 GMT

Or my favorite:

select col1, count(*)
From MyTable
Group by col1
Order by col1

To get a count of all the values of col1.

Tom

>Isn't column count same as the table count ? Do,
>
[quoted text clipped - 14 lines]
>>
>>Thanks

Signature

E-mail correspondence to and from this address may be subject to the
North Carolina Public Records Law and may be disclosed to third parties.

Reply to this Message