SELECT * FROM TBLSEMIAUTOHANDPICKING WHERE state <> '2' and rownum<=1 ORDER BY lineCode 而 SQL SERVER select top N from 表名