ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

­pºâ¤ë¦¨ªø²vªºSQL»yªk

­pºâ¤ë¦¨ªø²vªºSQL»yªk

½Ð°Ý§Ú¦³¤@¸ê®ÆªíÄæ¦ì¦³ , [¤½¥qID] , [¦~], [¤ë], [·í¤ëÀ禬], [·í¤ë²Ö­pÀ禬]
[¤½¥qID] , [¦~], [¤ë]¬°²Õ¦XÁä
§Ú°µ¤@­Ó¬d¸ßªí¨Ó­pºâ À禬¤ë¦¨ªø²v
»yªk¥Î¥H¤USQL
SELECT a.[¤½¥qID], a.[¦~], a.[¤ë], a.[·í¤ëÀ禬], a.[·í¤ë²Ö­pÀ禬],
(a.[·í¤ëÀ禬]-b.[·í¤ëÀ禬])*100/b.[·í¤ëÀ禬] AS ¤ë¦¨ªø²v
FROM ¤ëÀ禬ªí AS a
LEFT JOIN ¤ëÀ禬ªí AS b
ON (a.[¤½¥qID] = b.[¤½¥qID] and a.[¦~] = b.[¦~] and a.[¤ë]-1 = b.[¤ë] )
or (a.[¤½¥qID] = b.[¤½¥qID] and a.[¦~]-1 = b.[¦~] and a.[¤ë]=1 and b.[¤ë]=12 );

¦ý¸ê®ÆÀ˵ø®ÉÅܱo«ÜºC , ·Q°Ý¬O¤£¬OSQL»yªk®Ä²v³y¦¨ªº
­pºâ¦¨ªø²v­n«ç»ò¼g·|¤ñ¸û¦n?

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD