SELECT * FROM 7391 WHERE MOD(ID, 4)=1;有错吗
在ACCESS中新建的查询，
SQL语句如题，竟然报错，有点想不通
谢谢
问题点数：20、回复次数：1Top
1 楼wwwwb（）回复于 2006-03-03 13:32:21 得分 20
SELECT * FROM 7391 WHERE id MOD 4=1;Top
相关问题
- select (select top 1 from list where id in 问题
- sql="select count(article.ar_id),count(topic.topic_id) from article,topic where class_id="&request.querystring("class_id")这样写
- Where can I download mod_webapp.so?? SOS!!!!
- StrSQL:='select ID,NAME,PASSWORD,AREAID from person_info where id='+''''+ Strid + '''' + ';'; 这样行么？？
- select name from syscolumns where name ='od_serno' and id = object_id(N'iesa15d1')
- select id
- 如何使：select name from syscolumns where id=object_id('bhgzdescr')查出的数据不排序？
- 这个语句对吗?sql="select t_a.count(id),t_b.count(id) from t_a ,t_b where year(write_date)='"&rs(1)&"'
- string strComm = "select * from article where articleid="+id;的问题help
- set rs=db.fy("select * from dfdd where fwh_y_int="&bh & "order by id desc")
