I'm trying to think of couchdb equivalent of the following SQL query. SELECT author, count(*) as count FROM changes GROUP BY author ORDER BY count
To sort by count, I need to emit the count in the map function, but it is only available when it is queried. I know that this can achieved by cascading two couchdb databases. Is it possible to do this by using a single couchdb database? Anand