SQL Server features that are not supported by Azure SQL Database
SQL Server is in the Cloud as Windows Azure SQL Database, but in the Cloud, still have some limitations that...
2013-02-26
6,716 reads
SQL Server is in the Cloud as Windows Azure SQL Database, but in the Cloud, still have some limitations that...
2013-02-26
6,716 reads
An error that is known how to solve it, I was the victim today with it and when I started...
2013-02-11
29,306 reads
I’m so honored to be recognized as an MVP for SQL Server by Microsoft!
Thank you Microsoft and the SQL Server Community.
My...
2012-10-02
1,324 reads
After the successful installation of the SQL Server 2012, some shortcut keys can be possible to not work properly like...
2012-08-14
6,364 reads
SQL Server Team, has announced the Service Packe 2 available for the SQL Server 2008 R2.
All the details are here
Stay...
2012-07-27
1,393 reads
Another Tech Days Prishtina where I will speak about SQL Server 2012 for IT Pros. After a success event in...
2012-05-11
1,842 reads
MS has announced the new road for the SQL Server Certifications. All of the interested folks knows that the old...
2012-04-14
2,061 reads
I’m very excited for the invitation to present at TechDays Albania 2012, which will be held on April 19, 2012...
2012-04-14
1,826 reads
Many of the folks who are the PASS members, can have the possibility to watch 24 Hrs of PASS Spring...
2012-04-06 (first published: 2012-04-04)
1,947 reads
2012-03-06
1,430 reads
By Rayis Imayev
(2025-Feb-12) I will jump straight to the problem statement without a "boring" introduction, which, in...
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
I wrote a stream-of-consciousness post a few months ago about what I do in...
AI app development companies benefit a wide range of industries by making processes smarter,...
I'm a retired IT guy in his 80s fighting boredom by trying to learn...
I just joined and posted a brief profile. This is my first post. Please...
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, [total] int ) 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 SalesRank 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