Difference between revisions of "MoL Chapter 8 Lab"
Jump to navigation
Jump to search
(Created page with "<div class='qu'> <div class=imper>List all details from the weather table for stornoway for 1887 so that you can see the NULL value</div> <source lang='sql' class='def'> SELEC...") |
|||
| Line 4: | Line 4: | ||
SELECT * | SELECT * | ||
FROM weather | FROM weather | ||
| − | WHERE station='stornoway' | + | WHERE station='stornoway' AND yr=1892 |
</source> | </source> | ||
<source lang='sql' class='ans'> | <source lang='sql' class='ans'> | ||
| − | + | SELECT * | |
| + | FROM weather | ||
| + | WHERE station='stornoway' AND yr=1892 | ||
</source> | </source> | ||
</div> | </div> | ||
Revision as of 14:38, 22 December 2015
List all details from the weather table for stornoway for 1887 so that you can see the NULL value
SELECT *
FROM weather
WHERE station='stornoway' AND yr=1892
SELECT *
FROM weather
WHERE station='stornoway' AND yr=1892
