Is it possible to query like this in exposed Creating tempor kotlinlang #exposed

Is it possible to query like this in exposed? Crea...

aeruhxi

06/18/2021, 5:53 AM

Is it possible to query like this in exposed? Creating temporary variables using subquery. It's mysql.

Copy code

SELECT a.id, a.something, @rvar:= @rvar+1 
FROM a, (SELECT @rvar:= 0) r
ORDER BY .......

Copy code

SELECT a.id, a.something, @rvar:= @rvar+1 
FROM a INNER JOIN (SELECT @rvar:= 0) r
ORDER BY .......