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
    	)
    );