title: How to execute nested query in golang gorm
body: <p>I want to execute a query like below in golang gorm:</p>
  
  <pre><code>select * from MY_TABLE where MY_FIELD in (select max(MY_FIELD) as MY_FIELD from MY_TABLE group by ANOTHER_FIELD)
  </code></pre>
  
  <p>Is there a way besides raw query in gorm?</p>