counts in a db

[blackinwhite]

I have a table tblpeople,and columns peopleid, idcreated so on.

how can I write a count of peoplein the db.

[addstravel]

Try...


select count(peopleid) as 'COUNT' from tblpeople


and just read the field 'COUNT' as if a column field to retrieve the value.

hope this works....a bit rusty...

[blackinwhite]

I just worrying about deleting someone, so the count will not change?