Select to view content in your preferred language

Count records where two fields have distinct values

153
1
08-27-2024 10:55 AM
SanchezNuñez
Frequent Contributor

Good afternoon,

I am looking for a way to  count in a layer how many records have two fields distinct, and show  the result in a text box. 

Thanks

 

 

0 Kudos
1 Reply
SanchezNuñez
Frequent Contributor

This is what I need if I use a SQL Statement:

SELECT distinct
[ProjectNumber]
,[ProjectPage]
FROM ProjecTables



And the count will be


SELECT COUNT(*)
FROM (
SELECT distinct
[ProjectNumber]
,[ProjectPage]
FROM ProjecTables
) as dt

 

Please advise

0 Kudos