Re: recordcount per date ? could you do that?

In article <1159841614.560707.13620@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
dokter.cinta@xxxxxxxxx says...
dear all
its me again....
how are you today ????


i have some problems again
i have some records per date
and i want to count it per date

Untested, but it's going to look something like:

select "date", count(*) as I group by "date" from myTable


Keep in mind that if your field name is "date", you may run into trouble
because that's a reserved word in many SQL implementations. You might
want to change it to something like "SaleDate" or whatever.

.....

--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
.

Relevant Pages

  • Re: View Vs Table of base tables of view
    ... I create a view of x union y union z ... Remove the ns_ from if replying by e-mail (but keep posts in the ... newsgroups if possible). ...
    (comp.databases.sybase)
  • Re: View Vs Table of base tables of view
    ... because creating that table the first time will be ... Remove the ns_ from if replying by e-mail (but keep posts in the ... newsgroups if possible). ...
    (comp.databases.sybase)
  • Re: java network router
    ... Remove the ns_ from if replying by e-mail (but keep posts in the ... newsgroups if possible). ... Does it have to be Java? ...
    (comp.lang.java.softwaretools)
  • RE: Change "message delayed" time delay
    ... X Against HTML ... Remove the ns_ from if replying by e-mail (but keep posts in the ... newsgroups if possible). ...
    (microsoft.public.exchange.admin)
  • Re: Interacting with another application
    ... I have a project in which i have to interact with another application ... Remove the ns_ from if replying by e-mail (but keep posts in the ... newsgroups if possible). ...
    (microsoft.public.vb.general.discussion)