SELECT Distinct

SQL Server Query

            
SELECT DISTINCT City AS SupplierCity FROM Suppliers; 

            
        

Create SQL query with SqlQueryBuilder

            
var (sql, parameters) = new SqlQueryBuilder()  

  .Select().Distinct()  

  .Column("City", "SupplierCity")  

  .From("Suppliers")  

.Build(); 

            
        

Query build by SqlQueryBuilder

            
SELECT DISTINCT City AS SupplierCity
FROM Suppliers;


            
        

Parameters (If used)

Query Results: