SELECT * FROM (
SELECT PARENTID,
CHILDRENCODE,
CHILDRENCUSCODE ,
ROW_NUMBER() OVER(PARTITION BY CHILDRENCODE, CHILDRENCUSCODE ORDER BY PARENTID) num
FROM table) WHERE num<5;
SELECT PARENTID,
CHILDRENCODE,
CHILDRENCUSCODE ,
ROW_NUMBER() OVER(PARTITION BY CHILDRENCODE, CHILDRENCUSCODE ORDER BY PARENTID) num
FROM table) WHERE num<5;
SELECT A.*, row_number() OVER (PARTITION BY CHILDRENCODE,CHILDRENCUSCODE ORDER BY PARENTID) index from A )WHERE index <=5