Microsoft Business Intelligence Materials from Discussion at Jacksonville University
Today I had the wonderful pleasure for leading a discussion regarding the products, services, and tools Microsoft provides in the...
2017-04-10
97 reads
Today I had the wonderful pleasure for leading a discussion regarding the products, services, and tools Microsoft provides in the...
2017-04-10
97 reads
If you’ve been at least paying attention to my blog a little bit, you’ve probably noticed I occasionally blog about...
2017-01-31
1,112 reads
2016-11-14
481 reads
I had a call with a customer this morning discussing different ways to publish Power BI content and how to...
2016-10-20 (first published: 2016-10-12)
1,111 reads
If you have followed my blog for the past year or so you may remember when I posted a Power...
2016-09-01 (first published: 2016-08-23)
3,078 reads
For my second time, I was afforded the great opportunity to present virtually to the great people of the Madison...
2016-08-19
572 reads
Yesterday evening I had the distinct pleasure of presenting at the Jacksonville SQL Server Users Group on some of the...
2016-08-18
423 reads
Thank you to everyone that attended this past Tuesday’s webinar hosted by Pragmatic Works called Introduction to Power BI Desktop....
2016-07-15
598 reads
I’ve had this blog post in my mind to write for the past month or so and I’m finally just...
2016-07-07 (first published: 2016-06-29)
3,604 reads
Last night at approximately 9:28 PM EST the June 2016 release of Power BI Desktop dropped, which you can download...
2016-07-01
672 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) GOWhen 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