Tag: SQL

New Syntax Highligther

许多大型网站都在用的SyntaxHighlighter Evolved

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	<title>PHP Code Example</title>
</head>
<body>
	<h1>PHP Code Example</h1>

	<p><?php echo 'Hello World!'; ?></p>
</body>
</html>

void hello() {
    printf("Hello World!");
}

void main() {
    hello();
}

SELECT D.City_Name
FROM City D
WHERE NOT EXISTS (
	SELECT *
	FROM Customer C
	WHERE NOT EXISTS (
		SELECT *
		FROM Shipment S
		WHERE S.Cust_ID=C.Cust_ID
			AND D.City_Name=S.Destination
	)
);