Q&A: Can you do a nested SQL query in Responsys?

Although I have not heard this directly from Responsys, I believe you can execute any SELECT statements that can normally be executed on an ORACLE database. We run this SQL statement, where you can see nested select statements:

SELECT * FROM ( SELECT RANK() OVER (PARTITION BY A.EMAIL_ADDRESS_ ORDER BY A.CREATED_DATE_) RNK, A.* FROM $A$ A JOIN (SELECT EMAIL_ADDRESS_ FROM $A$ GROUP BY EMAIL_ADDRESS_ HAVING count(EMAIL_ADDRESS_) > 1) B ON (A.EMAIL_ADDRESS_ = B.EMAIL_ADDRESS_) ) WHERE RNK <> 1

One thought on “Q&A: Can you do a nested SQL query in Responsys?

  1. domain

    Great web site. A lot of helpful info here. I am sending it to a few friends ans additionally sharing
    in delicious. And certainly, thanks in your effort!

Leave a Reply

Your email address will not be published. Required fields are marked *