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
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
java.net: Nuances of the Java 5.0 for-each Loop
by 1 otherItem 9. Consider returning Iterable views rather than
implementing Iterable. The Java collections
classes can be used in for-each loops because they implement
java.lang.Iterable. If a class implements
java.lang.Iterable, then all its subclasses inheri
1
(4 marks)
