Delete me
From NewHaven Software Wiki
(Difference between revisions)
| Line 7: | Line 7: | ||
echo $v; // end of php code | echo $v; // end of php code | ||
?> | ?> | ||
| + | </source> | ||
| + | |||
| + | <source lang=sql> | ||
| + | -- select some data | ||
| + | SELECT a, b, COUNT(*) AS c, SUM(d) AS d | ||
| + | FROM MyTable | ||
| + | WHERE a > b | ||
| + | GROUP BY a,b | ||
| + | HAVING COUNT(*) > 1 | ||
</source> | </source> | ||
Revision as of 18:37, 19 February 2009
<?php $v = "string"; // sample initialization ?> html text <? echo $v; // end of php code ?>
-- select some data SELECT a, b, COUNT(*) AS c, SUM(d) AS d FROM MyTable WHERE a > b GROUP BY a,b HAVING COUNT(*) > 1
