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

×ö¾ØÕó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(left join,right jion,inner join)Á¬½ÓÏê½â

 ¹ØÓÚsqlÁ¬½Ó
Á¬½ÓÀàÐÍ
ÔÚ¹ØÏµ´úÊýÖУ¬Á¬½ÓÔËËãÊÇÓÉÒ»¸öµÑ¿¨¶û»ýÔËËãºÍÒ»¸öѡȡÔËËã¹¹³ÉµÄ¡£Ê×ÏÈÓõѿ¨¶û»ýÍê³É¶ÔÁ½¸öÊý¾Ý¼¯ºÏµÄ³ËÔËË㣬Ȼºó¶ÔÉú³ÉµÄ½á¹û
¼¯ºÏ½øÐÐѡȡÔËË㣬ȷ±£Ö»°Ñ·Ö±ðÀ´×ÔÁ½¸öÊý¾Ý¼¯ºÏ²¢ÇÒ¾ßÓÐÖØµþ²¿·ÖµÄÐкϲ¢ÔÚÒ»Æð¡£Á¬½ÓµÄÈ«²¿ÒâÒåÔÚÓÚÔÚˮƽ·½ÏòÉϺϲ¢Á½¸öÊý¾Ý¼¯ºÏ£¨Í¨³£ÊÇ±í£©£¬²¢²úÉú
Ò ......

SQL server ÈÕÖ¾ÎļþÇå³ý

´ò¿ª²éѯ·ÖÎöÆ÷£¬ÊäÈëÃüÁî¼´¿É¡£ DUMP TRANSACTION Êý¾Ý¿âÃû WITH NO_LOG
Èç¹û¾õµÃ·¢ÏÖLDFÎļþÕ¼ÓôÅÅ̿ռ仹ÊǺܴó¡£
Çë´ò¿ªÆóÒµ¹ÜÀíÆ÷--ÓÒ¼üµã»÷ÐèѹËõµÄÊý¾Ý¿â--ËùÓÐÈÎÎñ--ÊÕËõÊý¾Ý¿â--ÊÕËõÎļþ--Ñ¡ÔñÈÕÖ¾Îļþ--ÔÚÊÕËõ·½Ê½ÀïÑ¡ÔñÊÕËõÖÁXXM,ÕâÀï»á¸ø³öÒ»¸öÔÊÐíÊÕËõµ½µÄ×îСMÊý,µ÷ÕûÈ·¶¨¼´¿É¡£
Technorati ±êÇ©: SQL ......

SQL SERVER ²é¿´CPUÀûÓÃÂÊ

 --²é¿´CPUÀûÓÃÂÊ
-- CREATE PROCEDURE sp_GetTop10_CPU () AS
BEGIN
  SET NOCOUNT ON
  DECLARE @cinterval char(8)
  DECLARE @interval int
  SET @cinterval = '00:00:10'
  CREATE TABLE #thread
  (
    RUN INT NOT NULL,
    SPI ......

SQL »ù±¾½¨±íÓï¾ä

×÷Ϊ±¸Íü°É.ÔÚ»ú·¿ÀïÊäÈëµÄ.
/*CREATE TABLE Student
(Sno CHAR(9) PRIMARY KEY,
 Sname CHAR(20) UNIQUE,
 Ssex CHAR(2),
 Sage SMALLINT,
 Sdept CHAR(20)
);*/
/*CREATE TABLE Course
(Cno CHAR(4) PRIMARY KEY,
 Cname CHAR(40),
 Cpno CHAR(4),
 Credit SMALLINT,
&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ