delete from table where id >=4 就可以了,
如果你确定要用你的方式写的话
DELETE FROM table1 WHERE Id BETWEEN 4 AND (SELECT max(Id) FROM table1)
你的聚合函数用错了 改成max
id不一定是连续的,count统计的是行数
SQL简单语句 DELETE FROM table
1个回答
相关问题
-
sql="delete from xiaolei where dalei_mz='"&dalei_mz&"'"
-
sql选择题 大家帮忙看下9 下列（ ）在删除数据的语句在运行时不会产生错误信息。 A、DELETE * FROM AB
-
SQL语句理解 select * from B where (select count(1) as num from A
-
sql2005 求一条sql语句
-
c#中@符号疑惑string sql = @"DELETE Orders where UserId=@IdDELETE
-
SQL语句中的短语______。
-
I have delete you from my
-
The deletion of the deletion of the lost of the lost.From no
-
这句sql语句哪里有语法问题，错误提示说“关键字 'From' 附近有语法错误。”
-
sql根据已有的表建新表：create table tab_new as select col1,col2… from