SigmaGQ的博客

啊count(*)不是数全部有几条数据啊，是数全部有几个数据的啊，一条数据里10列就是10个具体数据啊

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+1 * FROM crm.r_dim_cust_cars WHERE (licenseNumber NOT IN (SELECT TOP N-1 licenseNumber FROM crm.r_dim_cust_cars))取第1