How is easy to work with JSON in SQL SERVER 2016 ?
If you are a developer then surely you might have used JSON (JavaScript Object Notation) but, if not then don’t...
2017-03-28
1,518 reads
If you are a developer then surely you might have used JSON (JavaScript Object Notation) but, if not then don’t...
2017-03-28
1,518 reads
To understand RLS (ROW LEVEL SECURITY) let’s understand the different problems first.Problem 1 Suppose, you have a Multi-tenant e-commerce website...
2017-03-27
949 reads
Data security is always one of the important points which can not be ignored. Nowadays if you are working for...
2016-11-27
890 reads
In the series of SQL SERVER 2016, this is a new post. in this post, we will discuss DATEDIFF_BIG and...
2016-10-22
802 reads
In the Series of SQL SERVER 2016, this is another post. Before Jumping in detail just think if you have...
2016-10-22
929 reads
This is another article in the series of SQL SERVER 2016 Journey . I am pretty much sure you might aware...
2016-10-16
1,502 reads
In the Series of SQL SERVER 2016 journey, this is our new article. In this article, we are sharing a...
2016-10-15
1,108 reads
Although, I know I am bit late to share this thing on our blog but it says in Indian proverb...
2016-10-11
661 reads
2016-03-29
481 reads
In last post tip #122, We discussed Merge transformation. Now in this tip, we are going to discuss Merge Join....
2015-12-31 (first published: 2015-12-18)
2,523 reads
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...
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...
hi, as we get further and further into netsuite connectivity, we want to block...
hi, as we get further and further into netsuite connectivity, we want to block...
Can this baselining and benchmarking sqlserver be done using extended events ? what are...
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