SELECT TOP 16 * FROM SM_CATE_GOODS_VIEW WHERE SC_CODE='0108' AND SG_BUY_YN='1' AND SG_MEM_LEVEL >= '99' ORDER BY SCG_SORT, SG_SEQ
36개의 상품이 있습니다.
SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY SG_SEQ DESC) AS ROW_NUM FROM (SELECT DISTINCT SG_SEQ,SG_CODE,SG_NAME,SG_MAKER,SG_ORIGIN,SG_MODEL,SB_SEQ,SBC_SEQ,SG_ICONS,SG_BUY_YN,SG_KEYWORD,SG_USE_STOCK,SG_RUNOUT_YN,SG_MIN_QTY,SG_OPTION_CNT,SG_MAX_QTY,SG_MEM_LEVEL,SG_MONEY_TYPE,SG_IMG_MAIN,SG_IMG_LIST,SG_VIEW_CNT,SG_WDATE,SGO_SEQ,SGO_PRICE,SGO_LIST_PRICE,SGO_SAVE_MONEY,SGO_NOW_QTY FROM SM_GOODS_LIST_VIEW WHERE SC_CODE LIKE '0108%' AND SG_BUY_YN='1' AND SG_MEM_LEVEL >= '99') A ) T WHERE T.ROW_NUM BETWEEN 1 AND 16 ORDER BY T.ROW_NUM
(주) 박영사 ㅣ 서울 금천구 가산디지털2로 53 210호 (주) 박영사 l 대표자 : 안종만ㅣ안상준 l 사업자등록번호 : 110-81-34015
개인정보책임자 : 임재무 l TEL : 02-733-6771 l FAX : 02-736-4818 l 이메일 : pys@pybook.co.kr
l 호스팅 정보 제공자 : (주)헬로웹
Copyright ⓒ 박영사|박영스토리. ALL Rights Reserved.