diff options
Diffstat (limited to 'extras/appengine/examples/subquery2.sql')
| -rw-r--r-- | extras/appengine/examples/subquery2.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/extras/appengine/examples/subquery2.sql b/extras/appengine/examples/subquery2.sql new file mode 100644 index 0000000..6c00a87 --- /dev/null +++ b/extras/appengine/examples/subquery2.sql @@ -0,0 +1 @@ +select user_id, count(*) as how_many from bboard where not exists (select 1 from bboard_authorized_maintainers bam where bam.user_id = bboard.user_id) and posting_time + 60 > sysdate group by user_id order by how_many desc;
\ No newline at end of file |