×ö¾ØÕó1£©¹ØÓÚsqlÓï¾ä
×ö¸ö¾ØÕ󣬯äʵ¾ÍÊǸö¶þάÊý×飬¹Ø¼üÊÇÒª´ÓÊý¾Ý¿âÀïµ÷ЩÊý¾Ý£¬sqlÓï¾ä²»ÊìÁ·£¬¾Í±ßѧ±ßÓã¬Í¬²½µØ¼ÇЩ±Ê¼Ç£¬·½±ã²éÔÄ
¹ØÓÚdistinctºÍorder by ·¢Á˸öÌû×Ó£¨µÚÒ»´ÎŶ£©
Ê×Ìû£º
ÓõÄÊÇoracleµÄÊý¾Ý¿â
Ä¿µÄÊÇÏëÑ¡³öΨһµÄuserid£¨ÔÓÐÖØ¸´Öµ£©,²¢ÇÒ°´ÕÕfileposÅÅÐò£¨ÔfileposÊÇ1£¬2£¬3.¡£¡£²»Öظ´µÄÐòºÅ£©
ÎÊÌ⣺ÒÔÏÂÓï¾ä¶¼²»ÄÜÂú×ãÒªÇó
1£©select distinct userid from bbsfile where rootid=371841£¨²»Öظ´£¬µ«ÊÇû°´Ë³ÐòÅÅ£©
2£©select distinct userid,filepos from bbsfile where rootid=371841 order by filepos(°´Ë³ÐòÅÅÁУ¬µ«ÊÇÓÐÖØ¸´)
3£©select distinct userid from bbsfile where rootid=371841 order by filepos(Óï·¨³ö´í)
¾ÍÊÇÏëÈóöÏÖÖØ¸´ÖµµÄÒ»Áа´ÕÕûÓÐÖØ¸´ÖµµÃÒ»ÁÐÅÅÐò
ÓÐÒ»¸ö¼òµ¥µÄ»Ø¸´½â¾öÁËÎÊÌâ
select userid from bbsfile where rootid=371841 group by userid order by min(filepos);
˼¿¼µÄ½Ç¶È±äһϾͳö½á¹ûÁË£¬ÕâÀï¹Ø¼üÊÇÓõ½ÁËmin Õâô¼òµ¥µÄ¾ÍÈ¥µôÁËÖØ¸´¡£
·ÖÎö£ºdistinct Ö»ÄÜÑ¡³öºóÃæ¸úµÄÒ»´®×ÖËù¹¹³ÉµÄÐУ¬ÈÃÿһÐж¼²»Ïàͬ¡£
µ«ÊÇ£¬order by ºóÃæµÄ¶«Î÷ÓÖ±ØÐë³öÏÖÔÚdistinct ºóÃæ ¡£ËùÒÔ³öÏÖÁËÉÏÊöÎÊÌâ¡£»òÐí»¹ÓбðµÄºÃµÄ½â¾ö°ì·¨£¬ÔÝûÏëµ½¡£
¿¼ÂÇʱ¼ä£ºÓÉÓÚʱ¼ä°üÀ¨ÈÕÆÚºÍʱ¼ä£¬Èç¹û½öÊÇfiletime=xxÄêÔÂÈÕ ·µ»Ø¿Õ£¬to_charºÜºÃÓ㬿ÉÒÔ½«Ê±¼äת»»ÎªÌض¨¸ñʽ¡£
trunc(filetime)='15-10ÔÂ-07' and to_char(filetime,'hh24') between 18 and 20 group by bbsuserid order by min(filepos)";
Ïà¹ØÎĵµ£º
±íµÄ½¨Á¢
¹ØÏµÊý¾Ý¿âµÄÖ÷ÒªÌØµãÖ®Ò»¾ÍÊÇÓñíµÄ·½Ê½×éÖ¯Êý¾Ý¡£±íÊÇSQLÓïÑÔ´æ·ÅÊý¾Ý¡¢²éÕÒÊý¾ÝÒÔ¼°¸üÐÂÊý¾ÝµÄ»ù±¾Êý¾Ý½á¹¹¡£ÔÚSQLÓïÑÔÖУ¬±íÓÐÑϸñµÄ¶¨Ò壬ËüÊÇÒ»ÖÖ¶þά±í£¬¶ÔÓÚÕâÖÖ±íÓÐÈçϹ涨£º
1)ÿһÕÅ±í¶¼ÓÐÒ»¸öÃû×Ö£¬Í¨³£³ÆÎª±íÃû»ò¹ØÏµÃû¡£±íÃû±ØÐëÒÔ×Öĸ¿ªÍ·£¬×î´ó³¤¶ÈΪ30¸ö×Ö·û¡£
2)Ò»Õűí¿ÉÒÔÓÉÈô¸ÉÁÐ×é³É£ ......
ROLLUP ÔËËã·ûÉú³ÉµÄ½á¹û¼¯ÀàËÆÓÚ CUBE ÔËËã·ûÉú³ÉµÄ½á¹û¼¯¡£ ÏÂÃæÊÇ CUBE ºÍ ROLLUP Ö®¼äµÄ¾ßÌåÇø±ð£º CUBE Éú³ÉµÄ½á¹û¼¯ÏÔʾÁËËùÑ¡ÁÐÖÐÖµµÄËùÓÐ×éºÏµÄ¾ÛºÏ¡£ ROLLUP Éú³ÉµÄ½á¹û¼¯ÏÔʾÁËËùÑ¡ÁÐÖÐÖµµÄijһ²ã´Î½á¹¹µÄ¾ÛºÏ¡£ ROLLUP Óŵ㣺 £¨£±£©ROLLUP ·µ»Øµ¥¸ö½á¹û¼¯£¬¶ø COMPUTE BY ·µ»Ø¶à¸ö½á ......
SQLÓïÑÔÓÉÃüÁî¡¢×Ӿ䡢ÔËËãºÍ¼¯ºÏº¯ÊýµÈ¹¹³É¡£ÔÚSQLÖУ¬Êý¾Ý¶¨ÒåÓïÑÔDDL£¨ÓÃÀ´½¨Á¢¼°¶¨ÒåÊý¾Ý±í¡¢×Ö¶ÎÒÔ¼°Ë÷ÒýµÈÊý¾Ý¿â½á¹¹£©°üº¬µÄÃüÁîÓÐCREATE¡¢DROP¡¢ALTER£»Êý¾Ý²Ù×ÝÓïÑÔDML£¨ÓÃÀ´ÌṩÊý¾ÝµÄ²éѯ¡¢ÅÅÐòÒÔ¼°É¸Ñ¡Êý¾ÝµÈ¹¦ÄÜ£©°üº¬µÄÃüÁîÓÐSELECT¡¢INSERT¡¢UPDATE¡¢DELETE¡£
Ò»¡¢SQLÓï¾ä
£¨1£©Select ²éѯÓï¾ä
Óï·¨£ºSE ......
2009Äê06ÔÂ24ÈÕ 09:47
create table [±íÃû]
(
[×Ô¶¯±àºÅ×Ö¶Î] int IDENTITY (1,1) PRIMARY KEY ,
[×Ö¶Î1] nVarChar(50) default 'ĬÈÏÖµ' null ,
[×Ö¶Î2] ntext null ,
[×Ö¶Î3] datetime,
[×Ö¶Î4] money null ,
[×Ö¶Î5] int default 0,
[×Ö¶Î6] Decimal (12,4) default 0,
[×Ö¶Î7] image null ,
)
É ......