title: select distinct row using single column value in Athena
body: <p>I am a newbie to database, so thanks for helping out.</p>
  
  <p>Given a table with 10 columns A, B, C, D, ..... having lots of non unique value in all columns, how to get rows with distinct value in column A. So if there are 5 rows with value 'eureka' and 'hippie' each in column A, I need single row for each.</p>
  
  <p>And it will be great if you can tell me multiple solutions and compare them with SQL counterpart. I searched it can be done with GROUP BY and PARTITION BY but somehow I am not able to get query work in Athena. Thanks!!!</p>