LoveUnix » ORACLE等数据库 » 数据删除
让LU留住您的每

一天 让LU博客留住您的每一天
2007-4-12 09:03 chtpku
数据删除

大家好 问一下 只删除数据库09:33到09:45的数据应该怎么写语句啊  谢谢
F_TIMB="09:33:21"
F_TIMB="09:34:21"
F_TIMB="09:35:21"
F_TIMB="09:36:21"
F_TIMB="09:39:21"
F_TIMB="09:40:21"
F_TIMB="09:42:21"
F_TIMB="09:43:21"
F_TIMB="09:45:21"
F_TIMB="09:47:21"
F_TIMB="09:49:21"
F_TIMB="09:51:21"

2007-4-12 11:03 boypoo
F_TIMB是什么类型?
假定是varchar2
则:
where  F_TIMB between ="09:33:00" and ="09:45:59"

2007-4-12 16:13 chtpku
[quote]原帖由 [i]boypoo[/i] 于 2007-4-12 11:03 发表 [url=http://www.loveunix.com/redirect.php?goto=findpost&pid=652108&ptid=71338][img]http://www.loveunix.com/images/common/back.gif[/img][/url]
F_TIMB是什么类型?
假定是varchar2
则:
where  F_TIMB between ="09:33:00" and ="09:45:59" [/quote]
谢谢

页: [1]
查看完整版本: 数据删除


Powered by Discuz! Archiver 5.5.0  © 2001-2006 Comsenz Inc.