anybody here know SQL?

[longhornrangler]

need to know how to do a count(select statement)

to return the number of rows in my query as a 3rd column

 

[jamesgoddard]

The format for the statement is...

select count(*) from {objectname}

Is that what you are after?

you can put in a where clause if it helps...

select count(*) from {objectname} where {columnname} = '{string}'