drupal - Drupla 8 database query MAX(id)

Question

I'm trying to run a query using the database api inside a form:

https://www.drupal.org/docs/8/api/database-api/dynamic-queries/introduction-to-dynamic-queries

$get_key = $this->connection->query("SELECT * FROM tablekeys WHERE id IN ( SELECT MAX(id) FROM tablekeys WHERE key = 'System' GROUP BY ip) ORDER BY id DESC");

The query returns my desired results.

The first select gets all fields and orders them by id desc.

The internal query selects the MAX(id) with where condition and groups the result by ip.

I have been trying to apply the API but it's throwing errors

$get_key = $this->connection->select('tablekeys', 'u')

->fields('u') Condition? ->condition('id', $another_db_cal?, 'IN') also the other db call ->fields('u', [MAX('id')])

Any help would be appreciated creating one db call or 2 dbs calls.

question from:https://stackoverflow.com/questions/65887924/drupla-8-database-query-maxid

Answer 1

Waitting for answers