General information
Category:
Coding, syntax & commands
I want to know how many invoices there are for each company.
select company from invoices into cursor X1
select Company, Cnt(Company)as Invoices from X1 group by 1
select Company, count(Company)as Invoices from X1 group by 1
The above all produce 1 per company even though some comapnies have 100.
select company, 1 as Inv from invoices into cursor X1
select Company, sum(Inv) rom X1 group by 1
Also, produces 1 per company.
Question 1: Why do the above not work?
Question2: How can I get the number of invoices per company with an SQL select?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only