SqlTest(2013-07-10)
USE WSS_Content
SELECT * FROM dbo.utTable32 WHERE DB0461A IN (SELECT DB0461A FROM dbo.utTable32 WHERE ID IN('1','2','2'))
---Row_NUMBER() OVER()
SELECT ROW_NUMBER()OVER(ORDER BY ID)AS RowNum,* FROM d
原创
2014-08-04 13:44:04 ·
986 阅读 ·
0 评论