Count Number of Rows in a SQL Table

[lyric0n]

I have a table that looks like this...

127.0.0.1 192.168.1.1
127.0.0.2 192.168.1.1
127.0.0.3 192.168.1.2

Using distinct statements, I can get it so it looks like

192.168.1.1
192.168.1.2

Now I need a way that I can count how many rows are there...I've tried just adding the count(column) but it gives back errors and doesn't report what I want.

I appreciate the help.

 

[indoaryaan]

Did you try putting the distinct values into a temp / separate table and then do count(*) or count(column)?

 

[lyric0n]

I've thought about that, but this will be accessed fairly often, and I'd rather not setup another table if there is a way to query the table.

Thanks

 

[r937]

select count(distinct ipnumber) as count_distinct from ...

r937.com | rudy.ca

 

[lyric0n]

Worked like a charm, thank you much.