sql :Select top 12 idxnum,title,tname, regdate, hit, y ,RG,RF From RESOM_NEW.dbo.TotalNotice_view Where y = 'Y' And title not in (Select Top 144 title From RESOM_NEW.dbo.TotalNotice_view Where y = 'Y' order by regdate desc) order by regdate desc
´º½º
Å×ÀÌºí ¸®½ºÆ®
¹øÈ£
|
Á¦¸ñ
|
¸®Á¶Æ®
|
µî·ÏÀÏÀÚ
|
°Ë»ö°á°ú°¡ ¾ø½À´Ï´Ù. |