April 2007
Common Queries
by 1 otherSELECT 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 otherSELECT 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
Haemin uptake and use as an iron source by Candida albicans: role of CaHMX1-encoded haem oxygenase -- Santos et al. 149 (3): 579 -- Microbiology
by 2 othersHaemin uptake and use as an iron source by Candida albicans: role of CaHMX1-encoded haem oxygenase -- Santos et al. 149 (3): 579 -- Microbiology
1
(5 marks)
