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

ÎÒÏëÓÃÒ»ÌõSQLÏÔʾÕâÑùµÄ½á¹û

²»ÖªµÀÕâÑùµÄÒªÇóÄܲ»ÄÜʵÏÖ£¿
±ÈÈçÎÒÓÐÒ»ÕűíT1£¬ÀïÃæÖ»ÓÐÒ»¸ö×Ö¶Î1
ÀïÃæÓÐ100Ìõ¼Ç¼£¬ÈçÏÂËùʾ£º
×Ö¶Î1
A1
A2
A3
A4
...
A100
ÎÒÏëÓÃÒ»ÌõSQLÏÔʾÕâÑùµÄ½á¹û
µÚÒ»ÁР   µÚ¶þÁР   ...        µÚÊ®ÁÐ
A1        A11                  A91
A2        A12                  A92
A3        A13                  A93
...        ...                  ...
A10        A20                  A100
²»Öª¿É·ñʵÏÖ£¿µ±È»£¬Ò²²»Ò»¶¨·Ö³ÉÊ®ÁУ¬¿ÉÄÜÊÇÎåÁеȵȣ¬Çë¸ßÊִͽ̡£Ð»Ð»
--¼ÙÉè×ֶβ»´æÔÚÏàֵͬ.
select
  max(case (px - 1) % 10 when 0 then ×Ö¶Î1 else '' end) [c1],
  max(case (px - 1) % 10 when 1 then ×Ö¶Î1 else '' end) [c2],
  max(case (px - 1) % 10 when 2 then ×Ö¶Î1 else '' end) [c3],
  max(case (px - 1) % 10 when 3 then ×Ö¶Î1 else '' end) [c4],
  max(case (px - 1) % 10 when 4 then ×Ö¶Î1 else '' end) [c5],
  max(case (px - 1) % 10 when 5 then ×Ö¶Î1 else '' end) [c6],
  max(case (px - 1) % 10 when 6 then ×Ö¶Î1 else '' end) [c7],
  max(case (px - 1) % 10 when 7 then ×Ö¶Î1 else '' end) [c8],
  max(case (px - 1) % 10 when 8 then ×Ö¶Î1 else '' end) [c9],
  max(case (px - 1) % 10 when 9 then ×Ö¶Î1 else '' end) [c10]
from
(
  select * , px = (select count(1) from t1 where ×Ö¶Î1 < t.×Ö¶Î1) + 1 from t1 t
) m
group by (px - 1) / 10
--Èç¹û×ֶδæÔÚÏàֵͬ.
--sql 2000ÐèҪʹÓÃÁÙʱ±í
select * , px = identity(int,1,1) into tmp from t1
select
  max(case (px - 1) % 10 when 0 then ×Ö¶Î1 else '' end) [c1],
  max(case (px - 1) % 10 when 1 then ×Ö¶Î1 else '' end) [c2],
  max(case (px - 1) % 10 when 2 then ×Ö¶Î1 else '' end) [c3],
  m


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿âSQL*plus³£ÓõÄÃüÁîºÍº¯Êý

 
OracleÖг£ÓõÄÃüÁîºÍº¯Êý£¬×ö¸öÕûÀí£¬ÒÔ±¸ÒÔºóÓõ½£¬·½±ã²éÔÄ¡£
 
³£ÓÃÃüÁ
 
Á¬½Ósqlplus
 
ÃüÁîÐÐÏÂÔËÐÐcmd½øÈ룬ÈçÒÔsysģʽµÇ½£¬ÃüÁîÈçÏ£º
 
(1).sqlplus "sys/zhb126 as sysdba"
 
(2).sqlplus/nolog connect sys/zhb126 as sysdba
 
(3).sqlplus scott ......

sql unionÓ÷¨ºÍsql union allÓ÷¨¼°ËüÃǵÄÔËÐÐЧÂÊ

sql unionÓ÷¨ºÍsql union allÓ÷¨,sql unionЧÂÊ
1¡¢sql unionÓ÷¨
sql unionÔÚ²éѯÖпÉÒÔ½«Á½¸öSQL Óï¾äµÄ½á¹ûºÏ²¢ÆðÀ´¡£Èç¹ûÕâÑù¿´µÄ»°£¬ UNION ¸ú JOIN ÊÇÏàËÆµÄ£¬Á½¸öÖ¸Áî¶¼¿ÉÒÔÓɶà¸ö±í¸ñÖÐߢȡ×ÊÁÏ¡£
sql unionµÄÒ»¸öÏÞÖÆÊÇÁ½¸ö SQL Óï¾äËù²úÉúµÄÀ¸Î»ÐèÒªÊÇͬÑùµÄ×ÊÁÏÖÖÀà¡£ÁíÍ⣬µ±ÎÒÃÇÓà UNIONÕâ¸öÖ¸Áîʱ£¬Î ......

VB+SQL±àдÊý¾Ý¿â¹ÜÀíϵͳ

     ²ÎÕÕ°¸Àý½Ì³Ì½¨Á¢µÄÊý¾Ý¿â¹ÜÀíϵͳÔÚÉõ¶à·½Ãæ¶¼´æÔÚÎÊÌâ¡£¿ÉÄÜÊÇÐÂÊÖ£¬²»¹ÜÊǶÔÓÚ´óÒ»¾Íѧ¹ýµÄVB±à³Ì»¹ÊÇÕâ¸öѧÆÚ¸Õ½Ó´¥µÄSQL£¬ºÜ¶àСÎÊÌâ³£³£³öÏÖÔÚµ÷ÊÔ¹ý³ÌÖС£ÏëÇëÊìϤʹÓÃÕâÁ½¸öƽ̨µÄ¸ßÊÖ°ïæָµãһϡ£
     1.ÈçºÎ½â¾öDataGridÖжà¸öcolumnºÍSQLÖжà¸ö±íµÄ°ó¶¨£¿Ä¿µÄ ......

²»ÖØÆôSQL·þÎñ£¬É¾³ýSQLServerϵͳÈÕÖ¾

    µ±SQLServerµÄϵͳÈÕÖ¾¹ý´ó£¬¾Í»áÒýÆðSQLServer·þÎñÆ÷ÎÞ·¨Æô¶¯µÈһϵÁÐÎÊÌâ¡£½ñÌìÎÒÓöµ½ÁËÕâ¸öÎÊÌ⣬ÔÚÍøÉÏËÑË÷ÁËһϣ¬½â¾ö·½·¨ÊÇɾ³ý¾Í¿ÉÒÔÁË£¬¿ÉÊǵ±Ç°µÄErrorLogÕýÔÚ±»SQLʹÓÃÎÞ·¨É¾³ý°¡£¬ÒªÉ¾³ýÖ»ÄÜÍ£Ö¹SQL·þÎñÆ÷£¬ÄѵÀ¾ÍûÓбðµÃ°ì·¨ÁËÂð£¿
    »Ø´ðÊǿ϶¨µÄ£ºÊ¹ÓÃÒÔÏ´洢¹ý³Ì£º ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ