Connor: Created page with "
Sometimes NULL values are given in tables, this might be because the data is unknown or is inappropriate. In the Parliament database a NULL value for party in the MSP table..."

2012-07-18T09:13:44Z

Created page with "<p>Sometimes NULL values are given in tables, this might be because the data is unknown or is inappropriate. In the Parliament database a NULL value for party in the MSP table..."

New page

<p>Sometimes NULL values are given in tables, this might be because the data is unknown or is inappropriate. In the Parliament database a NULL value for party in the MSP table indicates that the MSP concerned is not a member of any of the parties. In the party table a NULL value is used where the party does not have an official leader - or I couldn't find one. I rather like it that the Greens and the Scottish Socialist Party don't seem to have leaders - and it suits my purposes.</p>
<p>We can use the phrase IS NULL to pick out fields. We can use IS NOT NULL similarly.</p>
<div class='ht'>
<div class=params>schema:gisq</div>
The SELECT statement returns results from a <i>table</i>.
With a WHERE clause only some rows are returned.
This example shows the year that Athens hosted the Olympic games.
<source lang='sql' class='def e-oracle'>
SELECT code, name FROM gisq.party
WHERE leader IS NULL
</source>
<source lang='sql' class='def'>
SELECT code, name FROM party
WHERE leader IS NULL
</source>
</div>

Selecting NULL values. - Revision history

Connor: Created page with "Sometimes NULL values are given in tables, this might be because the data is unknown or is inappropriate. In the Parliament database a NULL value for party in the MSP table..."

Connor: Created page with "
Sometimes NULL values are given in tables, this might be because the data is unknown or is inappropriate. In the Parliament database a NULL value for party in the MSP table..."