例如删掉第3行DELETE FROM T1 WHERE ROWID= (SELECT RD FROM (SELECT ROWID RD, ROWNUM RN FROM T1) WHERE RN = 3);
例如删掉第3行DELETE FROM T1 WHERE ROWID= (SELECT RD FROM (SELECT ROWID RD, ROWNUM RN FROM T1) WHERE RN = 3); 大神,SQLServer 2008中不行啊。说ROWID是无效列名
例如删掉第3行DELETE FROM T1 WHERE ROWID= (SELECT RD FROM (SELECT ROWID RD, ROWNUM RN FROM T1) WHERE RN = 3); 大神,SQLServer 2008中不行啊。说ROWID是无效列名 我去,我没看错吧,这是oracle板块啊!
例如删掉第3行DELETE FROM T1 WHERE ROWID= (SELECT RD FROM (SELECT ROWID RD, ROWNUM RN FROM T1) WHERE RN = 3); 大神,SQLServer 2008中不行啊。说ROWID是无效列名 我去,我没看错吧,这是oracle板块啊! 让见笑了
1 2 3 4 5
11 22 33 44 55
111 222 333 444 555
1111 2222 3333 4444 5555
1111 2222 3333 4444 5555
删除下划线的那行
例如删掉第3行DELETE FROM T1
WHERE ROWID=
(SELECT RD FROM (SELECT ROWID RD, ROWNUM RN FROM T1) WHERE RN = 3);
WHERE ROWID=
(SELECT RD FROM (SELECT ROWID RD, ROWNUM RN FROM T1) WHERE RN = 3);
大神,SQLServer 2008中不行啊。说ROWID是无效列名
例如删掉第3行DELETE FROM T1
WHERE ROWID=
(SELECT RD FROM (SELECT ROWID RD, ROWNUM RN FROM T1) WHERE RN = 3);
大神,SQLServer 2008中不行啊。说ROWID是无效列名
我去,我没看错吧,这是oracle板块啊!
WHERE ROWID=
(SELECT RD FROM (SELECT ROWID RD, ROWNUM RN FROM T1) WHERE RN = 3);
大神,SQLServer 2008中不行啊。说ROWID是无效列名
我去,我没看错吧,这是oracle板块啊!
让见笑了