"SELECT * FROM [MainDBList] WHERE EXISTS (SELECT TOP 100 * FROM [MainDBList] WHERE (ID = [MainDBList].ID) ORDER BY ID DESC) ORDER BY FlowState"这句话我本意是想:显示表[MainDBList]中前100个记录,但他显示了所有![MainDBList]是同一个表,如果两个好象是可以的。why?
你要显示前100条记录直接用 SELECT TOP 100 FROM MainDBList ORDER BY FlowState就可以了。为什么要连接啊?
楼上说的对,不过可以这样 SELECT top 100 * FROM [MainDBList] WHERE EXISTS (SELECT TOP 100 * FROM [MainDBList] WHERE (ID = [MainDBList].ID) ORDER BY ID DESC) ORDER BY FlowState
SELECT TOP 100 FROM MainDBList ORDER BY FlowState就可以了。为什么要连接啊?
楼上说的对,不过可以这样
SELECT top 100 * FROM [MainDBList] WHERE EXISTS (SELECT TOP 100 * FROM [MainDBList] WHERE (ID = [MainDBList].ID) ORDER BY ID DESC) ORDER BY FlowState