Skip to Content (Press Enter)
2024-09-12 02-43-38
Deepsagar Dubey
61Views
2Comments
Solved
Outsystems Group by vs SQL Distinct
Question
SQL
Aggregate

Hi Team,

I have a scenario where i need distinct customer count so I want to know which is more perfect way between Aggregate with group by and count or a advance SQL query with Distinct statement.

Thanks

Deep

0
0
06 Mar 2023
Copy Link
2018-10-29 08-31-03
João Marques
 
MVP
Solution

Hi Deepsagar,


I would go for group by and count for two reasons:

  1. You can do it with an aggregate (quicker, no need to know SQL and SQL-syntax agnostic)
  2. Group by is more performant than a DISTINCT


Kind Regards,
João

2
0
06 Mar 2023
Copy Link
2024-09-12 02-43-38
Deepsagar Dubey

Hi João,

Yes you are correct, Thank you. 

0
0
06 Mar 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.