ÓÃJavaScriptÈçºÎдÔÚä¯ÀÀÍøÒµÊ±ÒªÊäÈëÑéÖ¤ÂëµÄ´úÂ룿ÈçµÇ½Óû§Ê±ÒªÊäÈëÑéÖ¤Âë....... Çë¸ßÊִͽ̣¡
Õâ¸öºÍJSû¹ØÏµ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡
ÑéÖ¤´úÂëÒ»°ãÓÃjavaµÄapplet»òflash×ö£¬ÕæÃ»¼ûµ½ÓÃjavaScript×öµÄ¡£
¶÷~ ¼´Ê¹ÄÜ×ö³öÀ´Ò²Ê§È¥ÁËÑéÖ¤ÂëµÄ×÷ÓÃÁË
HTML code:
<!DOCTYPE html PUBLIC "-//W3C/ ......
select (distinct no),flag from tbl group by no,flag
µÃµ½ÈçϽá¹û
no flag
01 1
01 0
02 0
ÏëºÏ²¢no=01µÄÁ½ÌõΪһÌõ
no flag
01 1
02 0
Ôõô¼ÓÌõ¼þµÃµ½ÒÔÉϽá¹ûÄØ£¿ »¹ÊÇÎÒµÄÓ ......
ÎÒдÁËÒ»¸ö´æ´¢¹ý³Ì£¬Ê¹ÓÃÓαê¶ÔÊý¾Ý½øÐвåÈë²Ù×÷£¬Éæ¼°µ½ºÜ¶à±í£¬ÆäÖÐһЩÊÇÖ÷´Ó±í¹ØÏµ£¬°´Ë³ÐòÏÂÀ´£¬Ö÷±íÉú³ÉÊý¾Ý£¬ÔÙÉú³É×Ó±íµÄ¡£
×î½üÅöµ½Ò»¸öÎÊÌ⣬ÓÉÓÚÓеÄÊý¾ÝÁ¿¹ý´ó£¬Ôì³ÉËٶȺÜÂý£¬ÔÚ10¼¸ÍòÌõÒÔÉÏ¡£ÏëÇë½ÌϸßÊÖ£¬ÓÐûÓкõķ½·¨½øÐÐÓÅ»¯£¬Ìá¸ßÏÂËÙ¶È£¡
ֻҪûÓÐÌ«¶à´ó¿éÍ·´ó¶ÔÏó£¬10¼¸Íò¶ÔORACLEÀ´ ......
±íAÊý¾ÝÈçÏÂ
id name
1 µ¥ÒøÇÙ
2 Àî¹úÕý
3 ÓȾê
4 ÖìÍõÓ¢
5 ÀîÎÄ
6 ÐÜÓ³ºì
7 ÍõÁáÁá
8 ÕÔ±ò
9 Ðì˳Ñà
10 ÖÜÓ¢
11 ÍõÑÞΰ
ÎÒÒª²éѯ³öÕâÑùµÄ½á¹û
id name
1 µ¥ÒøÇÙ
2 Àî¹úÕý
3 ÓȾê
4 ÖìÀîÓ ......
ÎÒ½¨Á¢Á½¸ö±í£¬½¨Á˲»Í¬µÄÐòÁС£ÎªÊ²Ã´Á½Õűíͬʱ×Ô¶¯Ôö³¤¡£
±ÈÈç¿ÆÄ¿±íÔö³¤µ½34£¬35
ÔÙ²åÈëѧÉúÐÅÏ¢¾ÍΪ£º36£¬37
¼ÌÐø²åÈë¿ÆÄ¿£º38£¬39
create table subject
(
sub_id number not null primary key,
sub_name varchar ......
ʹÓÃplsqlÁ¬½Ó·þÎñÆ÷µÄÊý¾Ý¿âʱ·¢ÏÖoracle²»ÄÜ·¢ÎÊÁË£¬ÌáʾʲôÎÒÒ²¼Ç²»µÃÁË¡£
Ô¶³Ì¹Û²ìoracleµÄ¼àÌý½ø³Ì·¢ÏÖ¼àÌý½ø³Ì¾ÓÈ»´ïµ½2G×óÓÒ¡£ÖØÆô¼àÌý»òÖØÆô·þÎñÆ÷ºó£¬¼àÌýÄÚ´æÓɸտªÊ¼µÄ6M×óÓÒ£¬°ë¸öСʱ×óÓÒÖð½¥Ôö¼Óµ½2G×óÓÒ£¬ÄÄλ´ó¸çÄܰïСµÜ·ÖÎöһϣ¡
¿´¿´¼àÌý³ÌÐòÈÕÖ¾Àï¶¼½²Ð©Ê²Ã´¡£
ÒýÓÃ
ʹÓÃplsqlÁ¬½Ó·þÎñÆ÷µÄÊý ......