I have a table in Cassandra, which stores the tenant's last updated details.
There is a timestamp field that updates usage. I need to find the last updated detail for every tenant.
So, consider the table structure to be like this :

[![enter image description here](https://i.stack.imgur.com/SDM3T.png)](https://i.stack.imgur.com/SDM3T.png)

Now, I need output like this:

[![enter image description here](https://i.stack.imgur.com/ahjN3.png)](https://i.stack.imgur.com/ahjN3.png)

I have written query like this :

```
aQueries = ['t1','t2','t3'];
const query = `SELECT * 
  FROM system_log_stats.keyspaces_sizes
  WHERE keyspace_name IN ? ORDER BY  timestamp_sec DESC LIMIT 1`;
const res = await client.execute(query, [aQueries], { prepare: true});

```

But the above query returns just 1 result.

Please note that I have to use where IN clause as I do not want to fetch for all tenants but only selected ones.