/SQL/TSQL Code Snippet For Optimized Sales Query

TSQL Code Snippet For Optimized Sales Query

SELECT
    'Customer'[Company Name], 
    'Date'[Date], 
    'Product'[Color],
    SUM ( 'Sales'[Quantity] )
FROM 'Sales'
    LEFT OUTER JOIN 'Customer' ON 'Sales'[CustomerKey] = 'Customer'[CustomerKey]
    LEFT OUTER JOIN 'Date' ON 'Sales'[OrderDate] = 'Date'[Date]
    LEFT OUTER JOIN 'Product' ON 'Sales'[ProductKey] = 'Product'[ProductKey];

Source: sqlbi.com

Similar codes

2 votes211 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
0 vote199 views1 answer
Oracle exchange partition
SQL
0 vote228 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote211 views1 answer
Top 3 salary in sql
SQL
0 vote219 views1 answer
Check constraint is violated
SQL
0 vote193 views1 answer
Find number of entries sql
SQL
-1 vote214 views1 answer
Mysql extract days
SQL
2 votes197 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote205 views1 answer
Postgres clear table
SQL
0 vote192 views1 answer
Mysql bash execute sql file
SQL