Delete me: Difference between revisions
From NewHaven Software Wiki
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| 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
