/* 游戏 */
-- 查询第一次登陆平台的日期
use master
go
if exists(select * from sysdatabases where name='LeetCode')
begin
drop database LeetCode
select 1 as deleted_LeetCode
end
create database LeetCode
use LeetCode
go
if exists(select * from sys.objects where name='Activity')
drop table Activity
create table Activity
(
player_id int,
device_id int,
event_date date,
games_played int,
primary key(player_id, event_date)
)
insert into Activity values
(1, 2, '2016-03-01', 5),
(1, 2, '2016-05-02', 6),
(2, 3, '2017-06-25', 1),
(3, 1, '2016-03-02', 0),
(3, 4, '2018-07-03', 5),
(1, 3, '2015-06-25', 1)
go
select *
from Activity
-- 1 row_number() over(partition by plarer_id order by event_date)
select player_id, event_date, row_number() over(partition by player_id order by event_date) as rank_
sqlserver 求最小日期
最新推荐文章于 2022-02-02 23:49:43 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)