Im trying to find 20.000(starting 5000 rows in) row with a hotmail domain in email, but I not sure what sql are allowed in SFMC. Can anyone give some hints on a solution for this?
SELECT * FROM table LIMIT 5000,20000 WHERE (substring_index(substr(email, instr(email, '@') + 1),'.',1)) = 'hotmail'
Im getting closer now, but it still dosnt work
SELECT * FROM ( SELECT *, Row_number() OVER (ORDER BY cardid) AS row, Substring( [email address],(Charindex('@', [email address])+1),Len( [email address]) - (Charindex('@', [email address]))) AS domain FROM usableusers ) a WHERE a.row > 0 AND a.row <= 500 AND a.domain = 'hotmail.com'