·¢Ð»°Ìâ
´òÓ¡

Çëhx817°æÖ÷£¬¿´Ò»ÏÂSTKFROMBLKÓ÷¨!лл!

Çëhx817°æÖ÷£¬¿´Ò»ÏÂSTKFROMBLKÓ÷¨!лл!

±ðÃû: È¡°å¿é³ÉÔ±´úÂë
ËùÊôÀà±ð: ×Ö·û´®º¯Êý  ²ÎÊýÊýÁ¿: 2

È¡µÃ°å¿é³ÉÔ±µÄ֤ȯ´úÂë
Ó÷¨:
STKFROMBLK(BLK,N)
·µ»ØBLK°å¿éÖеĵÚN¸ö³ÉÔ±µÄ֤ȯ´úÂë
ÀýÈç:
explain(1,STKFROMBLK('ÉϺ£A¹É', 1));
ÔÚ[½â]ÖÐÏÔʾ[ÉϺ£A¹É]°å¿éÖеĵÚ1¸ö³ÉÔ±µÄ֤ȯ´úÂë





ÎÒÏëÎʵÄÊÇÕâ¸öµÚN¸ö³ÉÔ±ÊÇÓÃʲô±ê×¼ÅÅÐòÈ¡³öµÄ£¿ÎÒÊÔÊÔ¿´ÁË£¬Ëü²»ÊÇÓÃÆ´Òô×ÖĸÅÅÐò£¬Ò²²»ÊÇÓôúÂëµÄÊý×ÖÅÅÐò£¿ËùÒÔÇë½Ì°æÖ÷¡£

TOP

°´ÕÕ±£´æÔÚ°å¿éÎļþÀïÃæµÄ˳Ðò
±ÈÈç¡°ST¡±°å¿é
ST.SBK ÎļþÄÚÈÝ£¬ÓüÇʱ¾´ò¿ª¿´
ÒýÓÃ:
?ÿÿ     {   SH600629 E@ SH600670 E@ SH600753 E@ SH600848 E@ SZ000011 E@ SZ000017 ..................
ÄÇô
EXPLAIN(1,STKFROMBLK('ST', 2));

¾ÍÏÔʾ 600670

TOP

лл!Õâ¸öÑù×ÓÒ»À´¾ÍûÓа취À´¸ü¸ÄÁË¡£ÒªÊÇÄÜ×Ô¼ºÉèÖÃËü¾ÍºÃÁË¡£

TOP

ʵ¼ÊÉϾÍÊÇÔÚ¶¯Ì¬ÏÔʾÆÁÀïÃæµÄ˳Ðò

TOP

·¢Ð»°Ìâ