SQLÖÐDATEADDºÍDATEDIFFµÄÓ÷¨
SQLÖÐDATEADDºÍDATEDIFFµÄÓ÷¨
ÈÕÆÚ:2008-07-17 ×÷Õß:ϲ騰С¶þ 來Ô´:PHPChina
ͨ³££¬妳ÐèÒª獲µÃ當ǰÈÕÆÚºÍ計ËãһЩÆäËûµÄÈÕÆÚ£¬ÀýÈ磬妳µÄ³ÌÐò¿ÉÄÜÐèÒªÅÐ斷Ò»個ÔµĵÚÒ»Ìì»òÕß×îááÒ»Ìì¡£妳們´ó²¿·ÖÈË´ó¸Å¶¼ÖªµÀÔõ樣°ÑÈÕÆÚ進ÐзָÄê¡¢Ô¡¢Èյȣ©£¬È»áá僅僅Ó÷ָî³ö來µÄÄê¡¢Ô¡¢ÈյȷÅÔÚ幾個º¯數ÖÐ計Ëã³ö×Ô¼ºËùÐèÒªµÄÈÕÆÚ£¡
¡¡¡¡ÔÚ這ƪÎÄÕÂ裡£¬ÎÒ將¸æ訴妳ÈçºÎʹÓÃDATEADDºÍDATEDIFFº¯數來計Ëã³öÔÚ妳µÄ³ÌÐòÖпÉÄÜ妳ÒªÓõ½µÄһЩ²»Í¬ÈÕÆÚ¡£
¡¡¡¡ÔÚʹÓñ¾ÎÄÖеÄÀý×Ó֮ǰ£¬妳±Ø須×¢ÒâÒÔϵÄ問題¡£´ó²¿·Ö¿ÉÄܲ»ÊÇËùÓÐÀý×ÓÔÚ²»Í¬µÄ機Æ÷ÉÏ執ÐеÄ結¹û¿ÉÄܲ»Ò»樣£¬這ÍêÈ«ÓÉÄÄÒ»ÌìÊÇÒ»個ÐÇÆÚµÄµÚÒ»Ìì這個設ÖÃ決¶¨¡£µÚÒ»Ì죨DATEFIRST£©設¶¨決¶¨ÁË妳µÄ繫統ʹÓÃÄÄÒ»Ìì×÷為Ò»ÖܵĵÚÒ»Ìì¡£ËùÓÐÒÔϵÄÀý×Ó¶¼ÊÇÒÔÐÇÆÚÌì×÷為Ò»ÖܵĵÚÒ»Ìì來½¨Á¢£¬Ò²¾ÍÊǵÚÒ»Ìì設ÖÃ為7¡£¼ÙÈç妳µÄµÚÒ»Ìì設Öò»Ò»樣£¬妳¿ÉÄÜÐèÒª調Õû這ЩÀý×Ó£¬Ê¹ËüºÍ²»Í¬µÄµÚÒ»Ìì設ÖÃÏà·ûºÏ¡£妳¿ÉÒÔͨ過@@DATEFIRSTº¯數來檢²éµÚÒ»Ìì設Öá£
¡¡¡¡為ÁËÀí½â這ЩÀý×Ó£¬ÎÒ們ÏÈ復習Ò»ÏÂDATEDIFFºÍDATEADDº¯數¡£DATEDIFFº¯數計Ëã兩個ÈÕÆÚÖ®間µÄС時¡¢Ìì¡¢ÖÜ¡¢Ô¡¢ÄêµÈ時間間¸ô總數¡£DATEADDº¯數計ËãÒ»個ÈÕÆÚͨ過給時間間¸ô¼Ó減來獲µÃÒ»個еÄÈÕÆÚ¡£ÒªÁ˽â¸ü¶àµÄDATEDIFFºÍDATEADDº¯數ÒÔ¼°時間間¸ô¿ÉÒÔ閱讀΢軟聯機幫Öú¡£
¡¡¡¡Ê¹ÓÃDATEDIFFºÍDATEADDº¯數來計ËãÈÕÆÚ£¬ºÍ±¾來從當ǰÈÕÆÚ
Ïà¹ØÎĵµ£º
±íjh03ÓÐÏÂÁÐÊý¾Ý£º
name¡¡score
aa¡¡¡¡99
bb¡¡¡¡56
cc¡¡¡¡56
dd¡¡¡¡77
ee¡¡¡¡78
ff¡¡¡¡76
gg¡¡¡¡78
ff¡¡¡¡50
1. Ãû´ÎÉú³É·½Ê½1,ScoreÖØ¸´Ê±ºÏ²¢Ãû´Î
SELECT *¡¡,¡¡Place=(SELECT COUNT(DISTINCT Score) from jh03 WHERE Score >= a.Score)
from jh03 a
ORDER BY Place
½á¹û
Name Score Pla ......
ʵÑéÄÚÈÝ£º
ÕÆÎÕSQL Server 2000µÄÔ¤±àÒë³ÌÐòNSQLPREP.EXEµÄʹÓã¨ÒԿα¾ÀýÌâ1½øÐе÷ÊÔ£©£»
ʵÑé²½Ö裺
Ò»¡¢Êý¾Ý¿â»·¾³ÅäÖÃ
1¡¢´´½¨xueshengÊý¾Ý¿â£¬½¨Á¢student±íµÈ£»
2¡¢¹Ø±Õsql server 2000·þÎñ¹ÜÀíÆ÷£»
3¡¢½«devtoolsÎļþ¼Ð¿½±´µ½£ºC:\Program Files\Microsoft SQL Server
4¡¢½«BinnÎļþ¼Ð¿½±´µ½£ºC:\Program ......
½éÉÜ
ÎÒÃÇÒ»ÆðÀ´×ö¸öʾÀý£¬ÔÚ.NETÖÐн¨Ò»¸öÀ࣬²¢ÔÚÕâ¸öÀàÀïн¨Ò»¸ö·½·¨£¬È»ºóÔÚSQL ServerÖе÷ÓÃÕâ¸ö·½·¨¡£°´ÕÕ΢ÈíËùÊö£¬Í¨¹ýËÞÖ÷ Microsoft .NET Framework 2.0 ¹«¹²ÓïÑÔÔËÐпâ (CLR)£¬SQL Server 2005ÏÔÖøµØÔöÇ¿ÁËÊý¾Ý¿â±à³ÌÄ£ÐÍ¡£ ÕâʹµÃ¿ª·¢ÈËÔ±¿ÉÒÔÓÃÈκÎCLRÓïÑÔ£¨ÈçC#¡¢VB.NET»òC++µÈ£©À´Ð´´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ºÍÓ ......
c06 --------------7545623Ìõ
c05---------------1032652Ìõ
vc01--------------427741Ìõ
SQL Statement from editor:
select c0602 "ÉÌÆ·±àÂë",c0625 "ÉÌÆ·ÌõÂë",
c0103 "ÉÌÆ·Ãû³Æ",c0104 "¹æ¸ñ",c060 ......
http://www.javaeye.com/topic/366991#
×÷Ϊһ¸ö¿ª·¢ÈËÔ±£¬¿ªÊ¼ÈÏÕæÏµÍ³Ñ§Ï°
Oracle SQLÒ²Ö»ÓÐÔÂÓ֮࣬ǰµÄ
SQLÖª
ʶ½ö½öÊÇÏîÄ¿ÀïÃæÓõ½Ê²Ã´¾ÍÈ¥¿´Ê²Ã´£¬¼òµ¥Ëµ¾ÍÊÇ
Read The Fxxking Guide¡£ÔÚϵͳѧϰ
Oracle
SQL֮ǰ£¬°³µÄÏë·¨¾ÍÊÇ“°´ÕÕÐèÇóÍê³É¹¦ÄÜ£¬Ê£ÏµĽ»¸ø
DBAÀ´´¦À픡£Õâ¸öÏë·¨´ÓÕûÌåÀ´¿´ÏÔ ......