Getting started with MySQL
The first step when getting started with MySQL is to get it installed and running. In this article, Robert Sheldon explains how to install it on Windows and create the first database and table.
2022-02-23
MySQL
Dealing with Failed SQL Migrations in MariaDB or MySQL
Although it is easy to get started with Flyway, there are times when real-life can trip you up. Discover the fastest ways to restore the previous version of the database, to recover from a failed Flyway migration that leaves the database in an indeterminate state, and then how to adapt your database development process to avoid these problems.
2021-10-25
Flyway with MariaDB for Those of a Nervous Disposition
This article from Phil Factor will get you up and running quickly with Flyway migrations on MariaDB or MySQL databases, from PowerShell.
2021-10-22
Azure Database for MySQL
In this article we take a look at setting up and configuring MySQL to run on Azure along with some performance metrics for this database platform running on Azure.
2020-10-02
Transfer data from SQL Server to MySQL
In this article we look at how to use PowerShell to transfer data from SQL Server to MySQL.
2020-09-04
Blogs
The hell of Git line endings and the (not so) simple fix
I wrote a stream-of-consciousness post a few months ago about what I do in...
Creating a GitHub Actions Self-Hosted Runner
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
Migrating from Azure PG Single Server to Flex with Azure VM and pg_dump/restore
This is more complicated than using the Azure Migration method, but because it’s maxed...
Forums
The Rank Window
Comments posted to this topic are about the item The Rank Window
The End of Azure Data Studio
Comments posted to this topic are about the item The End of Azure Data...
How to Develop Solutions with Fabric Data Warehouse: Data Engineering with Fabric
Comments posted to this topic are about the item How to Develop Solutions with...
Question of the Day
The Rank Window
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)
GO
When 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