We have created a awesome themeFar far away,behind the word mountains, far from the countries
INFO ½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤
¡á[SQL 7_1_1] Total ·¹ÄÚµå ¼ö SELECTSELECT COUNT(*) totcntFROM INSA_BBSWHERE BBS_CODE = #bbsCode#;
¡á[SQL 7_1_2] °Ô½ÃÆÇ ½ÃÀÛ ÆäÀÌÁö¿Í CountperPage ÀÔ·ÂSELECT A.BBS_CODE bbsCode, A.BBS_SEQ bbsSeq, A.TITLE title, A.CONTENT content, A.ID id , A.PW pw , A.BBS_DATE bbsDate , A.HIT_CNT hitCnt , A.NAME nameFROM INSA_BBS AWHERE 1=1____AND A.BBS_CODE = #bbsCode#ORDER BY BBS_SEQ DESCLIMIT #firstIndex#, #pageUnit#;
¡á¿¹ 7_2_1 || ´ë¿ë·® DBÀÇ ÆäÀÌ¡ ó¸®1SELECT BBS_SEQ, TITLE, NAME, WRITE_DATE, HIT_CNTFROM BOARDWHERE BBS_SEQ > :T_BBS_SEQAND ROWNUM <= 10AND :SW = 'D'UNIONSELECT /*+ INDEX_DESC(BOARD BOARD _PK) */BBS_SEQ, TITLE, NAME, WRITE_DATE, HIT_CNTFROM BOARDWHERE BBS_SEQ < :F_BBS_SEQAND ROWNUM <= 10AND :SW = 'U';
¡á¿¹ 7_2_2 || ´ë¿ë·® DBÀÇ ÆäÀÌ¡ ó¸®2SELECT SABUN, NAME, HP, YEARS, SEX, CARRIER, POS_GBN_CODE, ADDR1||ADDR2, PUT_YNFROM INSAWHERE SABUN > :T_SA