13 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:
02 April 2007
Alsacreations, examples and menus galleries in CSS and XHTML
by 4 othersIf you want to show your menu in this list, you only need to contact me,
and send me your menu (CSS integrated to HTML) either in HTML format either in a compressed ZIP if you use images. Please rememeber to add comments
to your CSS and to indicate compa
03 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
1
(4 marks)
