vmware Experts Database program EU, SQL Server Event – Sofia
I was honored to be part of very first & very high professional workshop about the vmware and SQL Server. Among...
2017-04-13
454 reads
I was honored to be part of very first & very high professional workshop about the vmware and SQL Server. Among...
2017-04-13
454 reads
PASS Summit 2016 is the biggest, largest, highest rated summit in the World for the Microsoft SQL Server & BI professionals,...
2016-02-05
780 reads
Take a look this awesome document for the Azure SQL DB technical deployment with lot of the details that you need...
2016-02-02
486 reads
I’m very exciting to announce that we will have next SQL Saturday event in Albania, Tirana, which is going to...
2014-06-19
839 reads
Another free resource for learning and gaining your knowledge that might be possible to earn MCSA Certifications with few efforts....
2014-02-12
1,447 reads
Announced and available for download the SQL Server 2014 CTP2:
Release Note:
http://msdn.microsoft.com/en-us/library/dn169381%28v=sql.15%29.aspx?lc=1033
Download Location:
http://technet.microsoft.com/en-us/evalcenter/dn205290.aspx
…and something that is very welcome for the community...
2013-10-16
1,410 reads
I’m honored to be recognized as SQL Server MVP for the 2nd time in row and thank you Microsoft to...
2013-10-16
1,025 reads
2013-07-31 (first published: 2008-07-15)
1,593 reads
SQL Saturday Kosovo #225, happened last week and I’m very happy that we did for the first time in Balkan...
2013-05-27
1,209 reads
I’m so exciting to announce that the SQL Saturday Kosovo is going to be held on May 18, 2013 and...
2013-03-07
1,078 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