ROW_NUMBER() over(order by CUSTOMER_PART

首页 > 技术文章 > ROW_NUMBER() over(order by CUSTOMER_PART_NUMBER ) id

ailanglang 2017-04-18 15:29 原文

   --ROW_NUMBER() 纯排序

　　SELECT ROW_NUMBER() over(order by CUSTOMER_PART_NUMBER ) id,CUSTOMER_PART_NUMBER,STEP_NUMBER FROM #整板镀锡的板子 
    where 1=1
    AND RKEY IN (28,183)
    AND  CUSTOMER_PART_NUMBER like '%ME14NU8552A0%'

ROW_NUMBER() over(order by CUSTOMER_PART_NUMBER ) id

推荐阅读