自行车停放架创意设计:select * from gbook order by pastdate desc limit 0,2
来源:百度文库 编辑:中科新闻网 时间:2024/10/05 09:35:20
同志那,我这哪儿错了啊,怎么总是说有语法错误,
郁闷,请教高手
是不是sqlserver2000不支持limit语句啊??????
郁闷,请教高手
是不是sqlserver2000不支持limit语句啊??????
limit 是mysql支持的,但SQLServer不支持
若表名/字段名都没错,就把最后那个“limit 0,2”先去掉试试
limit不是sqlserver2000的关键字吧!
select * from gbook order by pastdate desc limit 0,2
select from where like
select *from 部系表
select sum(*) from...where.....
select count(*) from 学生
select * from table1 where id in (select id from table2),
SELECT SUM(工资) FROM 职工
select * from v$bgprocess 是什么意思
select * from (select a.*,b.kczwmc kcmc from (select kcdm,max(McjN) Mcj,Max(kcxz) kcxz from (select
selece *from table1,table2与select*from table1 union select*from table2的区别