无详细内容 排座位 drop table v1;create table v1( name varchar(10), --人名, addres varchar(10) --去哪里,); insert into v1 values('my1','上海'); insert into v1 values('my2','北京'); insert into v1 values('my3','上海'); insert into v1 values('
排座位
drop table v1;
create table v1(
name varchar(10), --人名,
addres varchar(10) --去哪里,
);
insert into v1 values('my1','上海');
insert into v1 values('my2','北京');
insert into v1 values('my3','上海');
insert into v1 values('my4','江西');
insert into v1 values('my5','上海');
select * from v1;
drop table v2;
create table v2(
shipname varchar(10), --船名,
addres varchar(10) --去哪里
);
insert into v2 values('ship1','上海');
insert into v2 values('ship2','北京');
insert into v2 values('ship3','上海');
insert into v2 values('ship4','四川');
select * from v2;
select v1.name,v1.addres ,ROW_NUMBER() OVER(PARTITION BY v1.addres ORDER BY v1.addres DESC) AS 'RowNumber'
from v1 order by v1.name;
select v2.addres,v2.shipname ,ROW_NUMBER() OVER(PARTITION BY v2.addres ORDER BY v2.addres DESC) AS 'RowNumber'
from v2 order by v2.addres;
select x.name ,x.addres ,y.shipname from (select v1.name,v1.addres ,ROW_NUMBER() OVER(PARTITION BY v1.addres ORDER BY v1.addres DESC) AS 'RowNumber'
from v1) x left join (select v2.addres,v2.shipname ,ROW_NUMBER() OVER(PARTITION BY v2.addres ORDER BY v2.addres DESC) AS 'RowNumber'
from v2) y on x.addres =y.addres and x.RowNumber=y.RowNumber
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移，垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是，许多工具可以让 Windows 保持平稳运行。
C++高性能并发应用_C++如何开发性能关键应用
Java AI集成Deep Java Library_Java怎么集成AI模型部署
Golang后端API开发_Golang如何高效开发后端和API
Python异步并发改进_Python异步编程有哪些新改进
C++系统编程内存管理_C++系统编程怎么与Rust竞争内存安全
Java GraalVM原生镜像构建_Java怎么用GraalVM构建高效原生镜像
Python FastAPI异步API开发_Python怎么用FastAPI构建异步API
C++现代C++20/23/26特性_现代C++有哪些新标准特性如modules和coroutines
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
558
收藏
