select id,name from tbl_student where score>59 order by name limit 25
上面這條SQL指令可以在MySQL上執(zhí)行,但是在access上運(yùn)行會(huì)返回語(yǔ)法錯(cuò)誤。
在Access中,這條指令應(yīng)該寫成
select top 25 from tbl_student where score>59 order by name
http://blog.csdn.net/vanter/archive/2007/01/25/1493319.aspx
新聞熱點(diǎn)
疑難解答
圖片精選