How to do a row number on UNION of 3 queries

Topic Labels: Base design
667 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am trying to write a query of row number function in aws athena with 3 union queries, but my query fails stating “only one select statement allowed”. Any help would be appreciated as I am new to sql eg:

 select id, name, address from table 1
  select id, name, address from table 2
  select * (select id, name, address, row_number() over (partition by id order by id) from table 3
  ) as "t" where "t".row_num =1; 

Note: I am doing a row_num on 3rd table here because i want only unique values from 3rd table and distinct doesnt work directly on column using athena

0 Replies 0