I have a table which requires filtering based on the dates. The goal is to select the latest date when there is multiple data points like in the example above. The account 3000 in the dataframe occurs under two Groups but the up-to-date and correct result should only reflect the group X because it was ingested into Databricks very recently.
Tag: databricks-sql
How to join two total tables using sql?
For a university work we have two tables in sql: table1: table2: I need to join the two tables by adding the total number of people in each city. So I tried to do: However, if a city A appears in table 1 and does not appear in table 2 this would not work. The same would happen if a