Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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



ѧϰ


Ïà¹ØÎÊ´ð£º

asp¸úAccessÊý¾ÝÁ¬½ÓÎÊÌâ¡£

IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)

'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

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 updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ