public marks

PUBLIC MARKS from projects with tag query

April 2007

Common Queries

by 1 other
SELECT foo, MIN(bar) AS bar FROM tbl GROUP BY foo To return the highest value, and order top to bottom by that value:

Common Queries

by 1 other
SELECT foo, MIN(bar) AS bar FROM tbl GROUP BY foo To return the highest value, and order top to bottom by that value:

March 2007

MySQL AB :: MySQL 5.1 Reference Manual :: 3.2 Entering Queries

mysql> SELECT -> USER() -> , -> CURRENT_DATE; +---------------+--------------+ | USER() | CURRENT_DATE | +---------------+--------------+ | jon@localhost | 2005-10-11 | +---------------+--------------+ In this exam

Common Queries

SELECT clientpartyID, pCli.name AS Client, contractorpartyID, pCon.name AS Contractor FROM contracts INNER JOIN parties AS pCli ON contracts.clientpartyID = pCli.partyID INNER JOIN parties AS pCon ON contracts

February 2007

projects's TAGS related to tag query

about +   back +   because +   began +   cancel +   case +   char +   check +   column +   command +   completion +   count +   create +   current +   data +   date +   default +   diff +   document +   documents +   elements +   enter +   Entering +   exists +   expressions +   feature +   files +   find +   format +   from +   Given +   group +   have +   here +   http +   information +   inner +   into +   join +   le +   libxml +   libxslt +   line +   list +   many +   multiple +   mysql +   name +   next +   null +   options +   order +   parent +   parties +   patch +   pro +   problem +   procedure +   project +   prompt +   queries +   quote +   rows +   schema +   select +   semicolon +   server +   shell +   simple +   single +   some +   source +   sourceforge +   statement +   string +   stylesheets +   table +   tables +   text +   that +   this +   those +   time +   type +   unix +   user +   Using +   utility +   value +   values +   version +   waiting +   well +   what +   where +   which +   with +   xmlstarlet +   xpath +