±í1
FID F1 F2 F3
1 101 * 103
2 * 102 *
±í2
FID F1 F2
1 101 *
2 * 102
ÒªÇó×öµ½
Åжϱí1µÄ½á¹¹ÊÇ·ñºÍ±í2Ò»Ñù£¬Èç¹û²»Ò»Ñ ......
×î½üÔÚ¹¤×÷ÖÐÓöµ½ÁËÒ»ÌõsqlÓï¾ä,¾¡¹ÜÓëÎҵŤ×÷ûÓжà´óµÄÁªÏµ.µ«ÊÇÎÒÈÔÈ»Ïë¸ãÇå³þ.Ö»¿Éϧ±¾ÈËѧϰOracleʱ¼äÓÐÏÞ,ÔÙ¼ÓÉÏÄÜÁ¦µÄÖÆÔ¼,ËùÒÔÒ»Ö±²»ÊǺÜÃ÷°×.ËùÒÔÏëÇë¼Ù¸÷λ¸ßÊÖ°ï°ïæ,Ö¸µãÒ»ÏÂ.ÏÂÃæµÄsqlÓï¾äµÄº¬ÒåÊÇʲô:
SELECT
P_USER_LOGIN.LOGIN_NAME_ as loginName,
innerTable.REAL_NAME_ as realName,
inne ......
񡜧
aimmonth mark1 summark1
1 50 60
2 50 60
±íÖоßÌåÓжàÉÙÌõ¼Ç¼δ֪£¬¾ßÌåÊǼ¸Ô·ÝҲδ֪¡£
Ï£ÍûµÃµ½µÄ½á¹û
aimmonth mark1 summark1
1 50 60
&nb ......
Çë¸÷λ´óÏÀ°ïÏÂæ£º
Ö´ÐÐÒ»¸öSQLÓï¾ä£¬ÍùSQLÖеÄÒ»¸ö±íÖвåÈëÊý¾Ý£¬ÎÒÓÃDBGrid+Timer ÔÚ½çÃæÉÏÏÔʾ×îвåÈëµÄ10ÌõÊý¾Ýµ½½çÃæÉÏ£¬ÊµÊ±Ë¢Ð£¬µ«ÊÇÏÖÔÚÎÊÌâ³öÀ´ÁË£¬Êý¾Ý²åÈëÍê³ÉÖ®ºó£¬½çÃæÊ¼ÖÕÔÚË¢ÐÂ
ÇëÎÊÄܲ»ÄÜʵÏÖ£º¼ì²â±íµÄÊý¾Ý״̬£¬ÔÚÊý¾Ýµ¼ÈëÍê³ÉÖ®ºó£¬½çÃæÍ£Ö¹Ë¢Ð¹ý³Ì£¬½ûÓÃTimer ......
Êý¾Ý¿â½¨µÄʱºò·Å´íλÖÃÁË£¬¾ÍÔÚCÅÌ£¬ÏÖÔÚCÅ̿ռäÂúÁË£¬Òª¸øËüŲ¸öµØ£¬·ÅÔÚDÅÌ£¬Êý¾Ý¿âÆäËû·½ÃæÊ²Ã´¶¼²»±ä¡£ÓÐûÓÐʲô¼òµ¥±ã½ÝµÄ·½·¨£¿ÎÒÖªµÀ±¸·ÝÏÂÀ´ÔÙ»Ö¸´£¬ÄÇÊÇ¿ÉÒÔ£¬µ«ÓеãÂé·³£¬¾Í¸øÊý¾ÝÎļþ»»¸÷µØ£¬ÓÐûÓÐʲô¼òµ¥µÄ·½·¨£¿
Hi,
SQL code:
--1)ͼÐÎģʽ
1)ÓÒ»÷Êý¾Ý¿âTestÑ¡Ôñ Tasks ¡ú Detach
2)½«TestÊý¾Ý¿â ......
ѧÉú±í
--------------
ѧÉúÃû ÐÔ±ð
A ÄÐ
B Å®
C ÄÐ
D ÄÐ
E Å®
F ÄÐ
ѧÉúÇ©µ½±í
--------------
B Å®
C ÄÐ ......