SELECT NON EMPTY { [Measures].[Sales Amount] } ON COLUMNS, NON EMPTY { ([Product].[Category].[Category].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [Adventure Works] CELL PROPERTIES VALUE
SELECT NON EMPTY { [Measures].[Sales Amount] } ON COLUMNS, NON EMPTY { ([Product].[Category].[Category].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [Adventure Works] CELL PROPERTIES VALUE
SELECT SUM(sales), GROUPING_ID(year, quarter, month) FROM sales_table GROUP BY CUBE (year, quarter, month);
SELECT { [Measures].[Internet Sales Amount] } ON COLUMNS, HEAD ( ORDER ( [Customer].[Customer].[Customer].ALLMEMBERS, [Measures].[Internet Sales Amount], BDESC ), 10 ) ON ROWS FROM [Adventure Works]
SELECT product, SUM(sales), RANK() OVER (PARTITION BY product ORDER BY SUM(sales) DESC) rank FROM sales_table GROUP BY product;
Back-end App Developer
Front-end Web Developer
Full Stack Developer (Java)
Full Stack Developer (.Net)
Full Stack Developer (MEAN)
Full Stack Developer (MERN)
DevOps Engineer
Database Engineer (AzureSQL)
Database Engineer (Oracle)
Database Engineer (General)
Solution Architect (.NET)
Solution Architect (Java)
Solution Architect (Ruby)
Solution Architect (Python)
AI Engineer (Python)
Sr. AI Engineer (Python)
AI Strategist (Python)
Business Intelligence Engineer
Systems Analyst
Mainframe Developer (COBOL)
Mainframe Developer (General)