Re: Count(*) with additional query

stumbde <stumbde@email.msn.com> wrote: >Try Goup by Propertyname Yuck. Would that set a sticky bit? ><mrs_staceysmith@my-deja.com> wrote in message >news:8h206f$23g$1@nnrp2.deja.com... >> I would like to count rows when I do a select >> statement for specific columns, but count(*) does >> not like that: >> >> select count(*), >> propertyname, >> objectid >> from properties >> where propertyname='SITENAME'>> >> I would prefer not to, but do I have to put these >> into separate select statements? >> >> select count(*) >> from properties >> where propertyname='SITENAME'>> >> select propertyname, >> objectid >> from properties >> where propertyname='SITENAME'>> >> >> >> Sent via Deja.com http://www.deja.com/ >> Before you buy. > > carlos Currently on hiatus from unemployment. ---------------------- Do you do Linux? :) Get your FREE @linuxstart.com email address at: http://www.linuxstart.com