ACCESSÊý¾Ý¿â ×ö·ÖҳдSQLµÄÎÊÌâ
select top 20 * from tb
where ×Ö¶ÎÃû not in
(select top 10 ×Ö¶ÎÃû from tb)
ÎÒÖªµÀÓÃÕâÖÖ·½·¨¿ÉÒԵõ½10-20µÄÊý¾Ý
µ«ÊÇÈç¹ûÊý¾ÝºÜ¶à
±ÈÈçselect top 100020 * from tb
where ×Ö¶ÎÃû not in
(select top 100010 ×Ö¶ÎÃû from tb)ËäÈ»¿ÉÒԵõ½100010-10020Õâ10ÌõÊý¾Ý µ«ÊÇËٶȺÜÂý ÒòΪҪ´ò¿ªÇ°100020ºÍ10010µÄÊý¾Ý²¢ÇұȽÏ
ÇëÎÊ´ó¼ÒÔÚʹÓÃaccessÊý¾Ý¿âÊÇÈçºÎ·ÖÒ³µÄ
ÒòΪÊÇaccessµ±È»Ã»ÓÐsqlserverÄÇô¶àº¯ÊýÁË
LS?
±íÖн¨Ò»¸ö×ÔÔöÁУ¬È»ºó¸ù¾ÝÒ³ÊýºÍÒ³´óС£¬¼ÆËã³ö×ÔÔöÁеÄÖµ·¶Î§¡£ÕâÑùЧÂÊÓ¦¸ÃºÃºÜ¶à¡£
2lµÄ ÄãµÄÄÇÊÇɶ¶«Î÷
accessµÄ²»»á,°ï¶¥.
lkjhlkjhjkhjk
ÐèÒªÔÚIDÅÅÐò×Ö¶ÎÊÇÓÐË÷Òý¡£
SQL code:
select top 10 *
from (
select top 10000 *
from tbl01
order by id
) order by id desc
»òÕßÕâÑù »òÐí»á¿ìÉÏһЩ¡£
SQL code:
select top 10 * from tbl01
where id>(select max(id) from (
select top 10000 *
from tbl01
order by id ))
order by id
ѧϰ
Ïà¹ØÎÊ´ð£º
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)
'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and ......
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......