Field name of a count(*) column ?

[2004 IR Help]

By: Ombre - ombre

Field name of a count(*) column ?

2005-11-18 15:22

Hi,

I'm using a query like "select count(*),name from table ..." and i'm trying to get the field corresponding to count(*)....

 

 

PS : In my case, a normal "select * from table" using a sum (in order to replace the count(*)) won't fit because i've got thousands of lines in my database and i fear it will take a "long" time to fill my report.

 

 

 

 

By: Denny Valliant - xenden

RE: Field name of a count(*) column ?

2005-11-18 15:37

try "select count(*) AS thecount,name FROM table" so you know the name.

Otherwise it depends on the RDBMS I suppose (what database you use). So look at the DB docs to see what names it assigns it's calculated columns, if you can't name the column for some reason.