Pride and Prejudice... and Triggers
This post is part of #tsql2sday event π
I know, in the world of the database administrators and developers, the triggers are the ugly duck of the database development.They are...
2018-09-11
1 reads
This post is part of #tsql2sday event π
I know, in the world of the database administrators and developers, the triggers are the ugly duck of the database development.They are...
2018-09-11
1 reads
This post is part of #tsql2sday event :)I know, in the world of the database administrators and developers, the triggers...
2018-09-11
533 reads
One of the things I enjoy about my job is when I have to develop or review some T-SQL code, for my own projects or reviewing someones else code....
2018-09-10
7 reads
One of the things I enjoy about my job is when I have to develop or review some T-SQL code,...
2018-09-10
729 reads
JSON (JavaScript Object Notation) is a file format used to transmit data from various applications, very similar to XML, it also used to stored NoSQL unstructured data, and because...
2018-08-22
1 reads
JSON (JavaScript Object Notation) is a file format used to transmit data from various applications, very similar to XML, it...
2018-09-06 (first published: 2018-08-22)
3,700 reads
Views help our query writing by simplifying writing the same sentences and/or aggregations over and over again, but it has...
2018-08-17
323 reads
I am very happy to announce that after a long time struggling and filling all the requirements, we were able...
2018-08-16
716 reads
I have recently started as an author for MSSQLTips.com website, this is an excellent site where you can start writing...
2018-08-09
157 reads
When someone says still uses SQL Profiler.
Image is taken from hereAn ancient, dark place, a source of many legends and...
2018-07-23
1,536 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