What is this about This article will be about Power BI and PowerPoint collaborating. Both tools are well-known to anyone, particularly to those who are presenting data, charts and visualizations. Without a doubt, these are powerful tools for communicating and visually transmitting information. We can use them to hand over complex information in a simple, […]
2023-07-12
1,879 reads
I wrote a stream-of-consciousness post a few months ago about what I do in...
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
This is more complicated than using the Azure Migration method, but because it’s maxed...
Comments posted to this topic are about the item The Rank Window
Comments posted to this topic are about the item The End of Azure Data...
Comments posted to this topic are about the item How to Develop Solutions with...
I have this table and data:
CREATE TABLE [dbo].[SalesTracking]
(
[SalesDate] [datetime] NULL,
[SalesPersonID] [int] NULL,
[CustomerID] [int] NOT NULL,
[PONumber] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[paid] [bit] NULL
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [SalesTrackingCDX] ON [dbo].[SalesTracking] ([SalesDate]) ON [PRIMARY]
GO
INSERT dbo.SalesTracking
(SalesDate, SalesPersonID, CustomerID, PONumber, paid, total)
VALUES
('2024-03-15 10:45:55.067', 1, 1,'PO965' ,1, 100),
('2023-09-24 10:45:55.067', 1, 2,'PO627' ,1, 200),
('2022-07-02 10:45:55.067', 1, 3,'PO6' ,1, 300),
('2022-11-03 10:45:55.067', 1, 4,'PO283' ,1, 400),
('2022-11-26 10:45:55.067', 1, 5,'PO735' ,1, 500),
('2023-04-28 10:45:55.067', 1, 6,'PO407' ,1, 600),
('2022-09-09 10:45:55.067', 1, 7,'PO484' ,1, 700),
('2024-03-13 10:45:55.067', 1, 8,'PO344' ,1, 700),
('2024-04-24 10:45:55.067', 1, 9,'PO254' ,1, 800),
('2022-06-19 10:45:55.067', 1, 10,'PO344',1, 800)
GO
When I run this query, how many unique values are returned for the SaleRank column?
SELECT
st.SalesDate
, st.SalesPersonID
, st.total
, RANK () OVER (PARTITION BY st.SalesPersonID
ORDER BY st.total desc) AS SaleRank
FROM dbo.SalesTracking AS st;
See possible answers