ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anil <anilk...@gmail.com>
Subject Complex queries
Date Mon, 19 Dec 2016 14:48:09 GMT
HI,

are there any recommendations (other than affinity) for complex queries
like below.

SELECT DISTINCT b.id, b.filename, a1.name
FROM a a1
JOIN b
  ON b.id = a1.id
LEFT JOIN (select a.id, max(rank) latest from a group by a.id) a2
  ON a2.id = a1.id

Thanks.

Mime
View raw message