SELECT TOP 16 * FROM SM_CATE_GOODS_VIEW WHERE SC_CODE='0614' AND SG_BUY_YN='1' AND SG_MEM_LEVEL >= '99' ORDER BY SCG_SORT, SG_SEQ

39개의 상품이 있습니다.

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 '0614%' 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