General information
Category:
Coding, syntax & commands
>If I have a table that has 20 records in it, and the first 10 store the number 1 and the second 10 store the number 2 in it. Is there any way to use the SQL Select statement to count the number of occurences of 10 and 20 in one statemnet? Or do I have to use a calculate cnt() statement twice, once for 10 and once for 20.
>
>Thanks,
>Matt
You can use this :
select sum(iif(number = 1,1,0)) AS num1,SUM(IIF(number=2,1,0)) AS num2 FROM AA into cursor result
cursor result will have 1 row and 2 columns. Column 1 is number of records with
1 and column 2 is number of records with 2
ALEX
Previous
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