µoªí¤H |
¤º®e |
¥DÃD: ®w¦s¶qpºâÄæ¦ì §Æ±æ®w¦s¶q·í¬°0È®É, ´N¤£Åã¥Ü¥X¸Óµ§¾ã¦C¸ê®Æ |
jslin
¦^ÂÐ: 3
Æ[¬Ý: 38994
|
ª©±: SQL °Q½×°Ï µoªí©ó: ¬P´Á¥| ¤K¤ë 08, 2013 7:45 pm ¥DÃD: ®w¦s¶qpºâÄæ¦ì §Æ±æ®w¦s¶q·í¬°0È®É, ´N¤£Åã¥Ü¥X¸Óµ§¾ã¦C¸ê®Æ |
¦U¦ì¥ý¶i¦n
¤p§Ì¦³ÓSQL ®w¦s¶qpºâÄæ¦ì §Æ±æ®w¦s¶q·í¬°0È®É, ´N¤£Åã¥Ü¥X¸Óµ§¾ã¦C¸ê®Æ
¥H¤U¬°ì©lSQL»yªk¸òµ²ªG, ¤£ª¾¹DÀ³¸Ó¦p¦óקï .... ¤~¯à±Æ°£±¼®w¦s¶q¬°0¸ê®Æ(¦p§Ç¸¹ 35 39 41) ....?? ³Â·Ð¦U¦ì¥ý¶iÌ ... |
¥DÃD: SQL - ¥X²{³Ì¾aªñ 20121231¤é´Á¸ê®Æ |
jslin
¦^ÂÐ: 5
Æ[¬Ý: 43048
|
ª©±: SQL °Q½×°Ï µoªí©ó: ¬P´Á¤G ¤T¤ë 26, 2013 10:57 am ¥DÃD: SQL - ¥X²{³Ì¾aªñ 20121231¤é´Á¸ê®Æ |
§â¤é´Á´«ºâ¦¨¼Æ¦r,
®tÃB¨úµ´¹ïÈ.
XD
¤£¦n·N«ä MAX(LA007) ¤w¸g¬O¼Æ¦r
¯à§_§ó©ú½T«üÂI°g¬z «D±`ÁÂÁ ~~~ |
¥DÃD: SQL - ¥X²{³Ì¾aªñ 20121231¤é´Á¸ê®Æ |
jslin
¦^ÂÐ: 5
Æ[¬Ý: 43048
|
ª©±: SQL °Q½×°Ï µoªí©ó: ¬P´Á¤G ¤T¤ë 26, 2013 9:39 am ¥DÃD: SQL - ¥X²{³Ì¾aªñ 20121231¤é´Á¸ê®Æ |
µ²ªG§Æ±æ¬O¥uÅã¥Ü¨C¤@Ó«~¸¹¦b20130101000¤§«e©Ò²£¥Íªº³Ì«á¤@µ§¸ê®Æ(¤]´N¬O¤p©ó20130101¤é´Á¸ê®Æ)
Ãþ¦p:«~¸¹ 201002-02-12-055401 «~¦W §LªG_©Ó¬SELECT LA001 AS «~¸¹, MB002 AS «~¦W, MB003 AS ³W®æ, MB064 AS ®w¦ ... |
¥DÃD: §PÂ_ ¹F¦¨²v¦Ê¤À ªºÄæ¦ìÈ |
jslin
¦^ÂÐ: 3
Æ[¬Ý: 44348
|
ª©±: SQL °Q½×°Ï µoªí©ó: ¬P´Á¥| ¤E¤ë 02, 2010 12:03 pm ¥DÃD: §PÂ_ ¹F¦¨²v¦Ê¤À ªºÄæ¦ìÈ |
CASE WHEN ROUND(((LC005 - LC011) / LC005 * 100),2) > 70 THEN 'YES'
ELSE 'NO' END AS
«D±`¦a·PÁ ÁA¸Ñ,,,,
¦Û¤v¦A×¥¿¤@¤UÁYµu»yªk
SELECT LC002 AS ¦~¤ë, LC001 AS ¼t°Ó½s½X, MA002 AS ¼t°Ó¦Wº ... |
¥DÃD: §PÂ_ ¹F¦¨²v¦Ê¤À ªºÄæ¦ìÈ |
jslin
¦^ÂÐ: 3
Æ[¬Ý: 44348
|
ª©±: SQL °Q½×°Ï µoªí©ó: ¬P´Á¥| ¤E¤ë 02, 2010 10:38 am ¥DÃD: §PÂ_ ¹F¦¨²v¦Ê¤À ªºÄæ¦ìÈ |
¦³¤@¬qSQL»yªk
SELECT LC002 AS ¦~¤ë, LC001 AS ¼t°Ó½s½X, MA002 AS ¼t°Ó¦WºÙ, LC005 AS ¤ë¥æ³fÁ`µ§¼Æ, LC011 AS ¤ë¹O´ÁÁ`µ§¼Æ ,
ROUND(((LC005 - LC011) / LC005 * 100),2) AS ¹F¦¨²v¦Ê¤À¤ñ
FROM HTWF11..PURL ... |
¥DÃD: sql¦X¨Öªí®æ»yªk ? |
jslin
¦^ÂÐ: 1
Æ[¬Ý: 11353
|
ª©±: SQL °Q½×°Ï µoªí©ó: ¬P´Á¤ ¥|¤ë 10, 2009 1:02 pm ¥DÃD: sql¦X¨Öªí®æ»yªk ? |
¤j®a¦n
§Ú¦³Ç¬q¹L±b´Á¶¡±ø¥ó, ¤À§O¬O 20080101 ~ 20081231 ¥Nªí´Áªì ¸ò 20090101 ~ 20091231 ¥Nªí¥»´Á
select t2.acctname, t1.fathernum, sum(t3.debit) as ´Áªìɾl, sum(t3.credit) as ´Áªì¶U¾l, sum(t1.cur ... |
¥DÃD: foxpro ¬O§_¥i¥H³]p¤@®M©Ò¿× ¥Í²£±Æµ{ ¨t²Î?? |
jslin
¦^ÂÐ: 6
Æ[¬Ý: 7595
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤Q¤ë 22, 2008 11:33 pm ¥DÃD: foxpro ¬O§_¥i¥H³]p¤@®M©Ò¿× ¥Í²£±Æµ{ ¨t²Î?? |
¬O§_¦³ ¥Í²£±Æµ{ Sample ¥i¥H§ä¨ì¤U¸ü°Ñ¦ÒÁÂÁÂ~~~ |
|