Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COUNTing my SELECTion
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00850715
Message ID:
00850721
Views:
16
This message has been marked as the solution to the initial question of the thread.
Try
SELECT t_date, user, COUNT(DIST pay_track), SUM(payment)  FROM u_hpay ;
	GROUP BY t_date, user  INTO ARRAY uhp_tmp
>Hello Foxperts,
>
>Working in FPD/2.5 (!), I've got most of what I need from this statement:
>
SELECT t_date, user, COUNT(pay_track), SUM(payment)  FROM u_hpay ;
>	GROUP BY t_date, user  INTO ARRAY uhp_tmp
>The COUNT() is the focus of this question:
>I'm getting the number of pay_track entries (as expected).
>How can I get the number of unique pay_track entries?
>TIA,
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform