add distinct function example 4

XiaoyuMSFT · XiaoyuMSFT · commit abdd38d83b32 · 2020-10-07T19:33:01.000-07:00
diff --git a/docs/t-sql/statements/create-materialized-view-as-select-transact-sql.md b/docs/t-sql/statements/create-materialized-view-as-select-transact-sql.md
@@ -108,7 +108,7 @@ When MIN/MAX aggregates are used in the SELECT list of materialized view definit
 A materialized view in Azure data warehouse is similar to an indexed view in SQL Server.  It shares almost the same restrictions as indexed view (see [Create Indexed Views](/sql/relational-databases/views/create-indexed-views) for details) except that a materialized view supports aggregate functions.   
 
 >[!Note]
->Although CREATE MATERIALIZED VIEW does not support COUNT(), DISTINCT, COUNT(DISTINCT expression), or COUNT_BIG (DISTINCT expression), SELECT queries with these functions can still benefit from materialized views for faster performance as the Synapse SQL optimizer can automatically re-write those aggregations in the user query to match existing materialized views.  For details, check this article's example section. 
+>Although CREATE MATERIALIZED VIEW does not support COUNT, DISTINCT, COUNT(DISTINCT expression), or COUNT_BIG (DISTINCT expression), SELECT queries with these functions can still benefit from materialized views for faster performance as the Synapse SQL optimizer can automatically re-write those aggregations in the user query to match existing materialized views.  For details, check this article's example section. 
 
 Only CLUSTERED COLUMNSTORE INDEX is supported by materialized view. 
 
