Mercurial > urweb

comparison tests/subquery.ur @ 1192:9c82548c97e9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Subquery FROM items
author Adam Chlipala <adamc@hcoop.net>
date Thu, 25 Mar 2010 16:06:04 -0400
parents 61c3139eab12
children
comparison
equal deleted inserted replaced
1191:61c3139eab12 1192:9c82548c97e9
4 v <- queryX1 (SELECT t.A, t.C 4 v <- queryX1 (SELECT t.A, t.C
5 FROM t 5 FROM t
6 WHERE t.B = (SELECT MAX(U.B) AS M 6 WHERE t.B = (SELECT MAX(U.B) AS M
7 FROM t AS U 7 FROM t AS U
8 WHERE U.A = t.A)) 8 WHERE U.A = t.A))
9 (fn r => <xml>{[r.A]},{[r.C]};</xml>); 9 (fn r => <xml>{[r.A]},{[r.C]};</xml>);
10 return <xml>{v}</xml> 10 v' <- queryX1 (SELECT t.A, t.C
11 FROM (SELECT t.A AS A, MAX(t.B) AS B
12 FROM t
13 GROUP BY t.A) AS Maxes
14 JOIN t ON t.A = Maxes.A AND t.B = Maxes.B)
15 (fn r => <xml>{[r.A]},{[r.C]};</xml>);
16 return <xml><body>
17 {v}<br/>
18 {v'}
19 </body></xml>