SELECT TOP 1 * FROM crm.r_dim_cust_cars WHERE (licenseNumber NOT IN (SELECT TOP N-1 licenseNumber FROM crm.r_dim_cust_cars))
SELECT TOP m+
SQL Server 取第N行数据(N~N+m行数据)
最新推荐文章于 2022-01-17 00:01:50 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)
SELECT TOP 1 * FROM crm.r_dim_cust_cars WHERE (licenseNumber NOT IN (SELECT TOP N-1 licenseNumber FROM crm.r_dim_cust_cars))
SELECT TOP m+