[Couchdb Wiki] Trivial Update of "GaganSaksena" by Gaga nSaksena

[Apache Wiki]

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Couchdb Wiki" for 
change notification.

The "GaganSaksena" page has been changed by GaganSaksena.
http://wiki.apache.org/couchdb/GaganSaksena?action=diff&rev1=5&rev2=6

--------------------------------------------------

  {{{
  CREATE TABLE Foo ( 
    Name CHAR(256),
-   Id INTEGER,
+   Age INTEGER,
    StartDate DATE
  );
  }}}
  ||<tablewidth="80%">'''SQL''' ||'''Map''' ||'''Reduce''' ||'''Notes''' ||
- ||SELECT COUNT(*) FROM Foo; ||function (doc) {  // todo } ||_count ||         
    ||
+ ||SELECT COUNT(*) FROM Foo; ||function (doc) {  emit(doc._id, 1); } ||_count 
||             ||
- ||SELECT COUNT(*) FROM Foo WHERE Foo.bar ="value"; ||function (doc) {  // 
todo } ||_count ||Fetch view with ?key=value ||
+ ||SELECT COUNT(*) FROM Foo WHERE Foo.Age ="21"; ||function (doc) {  
emit(doc.age, null); } ||_count ||Fetch view with ?key=21 ||
- ||SELECT DISTINCT bar FROM Foo; ||function (doc) {  // todo } ||             
||             ||
+ ||SELECT DISTINCT Age FROM Foo; ||function (doc) {  emit(doc.age, true); } || 
function (key, value) { // todo }   ||             ||
  ||GROUP BY example ||function (doc) {  // todo } ||             ||            
 ||
  ||GROUP BY with SORT BY example ||function (doc) {  // todo } ||             
||             ||