T-SQL Tuesday #84: Growing New Speakers
This month's #tsql2sday is being hosted by Andy Yun (b|t) and is about helping new speakers.
I have only been speaking...
2016-11-08
414 reads
This month's #tsql2sday is being hosted by Andy Yun (b|t) and is about helping new speakers.
I have only been speaking...
2016-11-08
414 reads
This month's #tsql2sday is being hosted by Andy Yun (b|t) and is about helping new speakers.
I have only been speaking...
2016-11-08
212 reads
Got back from Summit on Saturday and I’m still totally in the moment. I came back with so many new...
2016-11-03
413 reads
Got back from Summit on Saturday and I’m still totally in the moment. I came back with so many new...
2016-11-03
195 reads
I think the title is fairly descriptive so let me put a little context around it for you. In my...
2016-10-25
758 reads
I think the title is fairly descriptive so let me put a little context around it for you. In my...
2016-10-25
283 reads
Question: Who owns your availability groups?
The person who creates the AG becomes the owner by default. Did you know that...
2016-10-20
15,162 reads
Question: Who owns your availability groups?
The person who creates the AG becomes the owner by default. Did you know that...
2016-10-20
274 reads
#TSQL2SDAY is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam...
2016-10-11
380 reads
#TSQL2SDAY is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam...
2016-10-11
197 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