New pages

Jump to navigation Jump to search
New pages
Hide registered users | Hide bots | Show redirects
  • 02:06, 1 June 2022Selecting NULL values./ja (hist | edit) ‎[1,336 bytes]Kobashi.kaz (talk | contribs) (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 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 p...")
  • 01:57, 1 June 2022Using Null/ja (hist | edit) ‎[5,679 bytes]Kobashi.kaz (talk | contribs) (Created page with "{{Languages| Using_Null}} <div class='ref_section'> <table class='zoo db_ref'> <caption>teacher</caption> <tr> <th>id</th> <th>dept</th> <th>name</th> <th>phone</th> <th>mobile</th> </tr> <tr> <td align='right'>101</td> <td align='right'>1</td> <td>Shrivell</td> <td align='right'>2753</td> <td>07986 555 1234</td> </tr> <tr> <td align='right'>102</td> <td align='right'>1</td> <td>Throd</td> <td align='right'>2754</td> <td>07122 555 1920</td> </tr> <tr><td align='right'>...")
  • 06:09, 26 May 2022CASE/ja (hist | edit) ‎[1,253 bytes]Kobashi.kaz (talk | contribs) (Created page with "{{Languages| CASE}} <table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>CASE WHEN b1 THEN v1 END</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr> <tr><td align='left'>ingres</td><td>Yes</td><td></td></tr> <tr><td align='left'>mysql</td><td>Yes</td><td></td></tr> <tr><td align='left'>oracle</td><td>Yes</td><td></td></tr> <tr><td align='left'>postgres</td><td>Y...")
  • 05:54, 26 May 2022Get to the point/ja (hist | edit) ‎[2,803 bytes]Kobashi.kaz (talk | contribs) (Created page with "{{Languages|Get_to_the_point}} <h3>Movie Database: The JOIN</h3> <p> The obvious questions about this database involve all three tables. Who appear in such-and-such a film, or which films has so-and-so appeared in. In fact we can answer some of these questions using nested <code>SELECT</code> statements that have already been covered. </p> <p>A join allows us to link two tables which have a "common" field. The id field of the actor table is referred to by the actorid fie...")
  • 08:13, 25 May 2022Aggregates with DISTINCT/ja (hist | edit) ‎[1,123 bytes]Kobashi.kaz (talk | contribs) (Created page with " <h3>Nobel database</h3> <h2>COUNT DISTINCT</h2> <p>You can find the number of <i>different</i> values using COUNT with DISTINCT</p> <p>In 1915 four prizes were awarded in three different subjects:</p> <table class='NoBorder'><td><pre>SELECT yr, subject, winner FROM nobel WHERE yr=1915</pre> </td><td> <table border="1" class="Bordered" style=""><tr> <th>yr</th> <th>subject</th> <th>winner</th> </tr> <tr> <td align="right">1915</td> <td>Chemistry</td> <td>Rich...")
  • 07:26, 11 May 2022LaurenTest (hist | edit) ‎[2,739 bytes]Andr3w (talk | contribs) (Created page with "{{Languages}} <div class="ref_section"> <table class='db_ref'><caption>world</caption> <tr><th>name</th><th>continent</th><th>area</th> <th>population</th><th>gdp</th></tr> <tr><td>Afghanistan</td><td>Asia</td><td class="r">652230</td><td class="r">25500100</td><td class="r">20343000000</td></tr> <tr><td>Albania</td><td>Europe</td><td class="r">28748 </td><td class="r">2831741 </td><td class="r">12960000000 </td></tr> <tr><td>Algeria</td><td>Africa</td><td class="r">2381...")
  • 18:49, 9 May 2022HTLWienWest/deleteme (hist | edit) ‎[4 bytes]GRUH (talk | contribs) (Created page with "TEST")
  • 07:53, 9 May 2022HTLWienWest/Group By Having 01 (hist | edit) ‎[4,603 bytes]GRUH (talk | contribs) (Created page with "__TOC__ == Einleitung == Schalten Sie in den Einstellungen (Zahnrad oben rechts) auf die SQL Engine : MySQL um! == Die Tabelle world == <div class="ref_section"> <pre class=output> +-------------------+---------+-------+----------+------------+----------------+ |name |continent|area |population|gdp |capital | +-------------------+---------+-------+----------+------------+----------------+ |Afghanistan |Asia | 652230| 255001...")
  • 18:36, 8 May 2022HTLWienWest/SMUE 2022-05-09 5ABIF (hist | edit) ‎[6,455 bytes]GRUH (talk | contribs) (Created page with "__TOC__ == Einleitung == Schalten Sie in den Einstellungen (Zahnrad oben rechts) auf die SQL Engine : MySQL um! <br> Geben Sie zu jeder Frage das erforderliche SQL Statement ein. Als Hilfestellung sehen Sie unter der jeweiligen Frage das zu erwartende Ergebnis.<br> <div class='qu'> Setzen Sie im unten angegeben SQL Statement Ihren Namen ein und führen Sie es aus.<br> '''Achten Sie darauf, dass bei der Abgabe als PDF hier ihr Name steht. Abgaben ohne Namen werden MIT N...")
  • 16:24, 8 May 2022HTLWienWest/SMUE 2022-05-09 2ACIF (hist | edit) ‎[6,455 bytes]GRUH (talk | contribs) (Created page with "Hintergrund *Gäste übernachten in einem kleinen Hotel. *Jede Buchung wird in der Tabelle '''booking''' erfasst, das Datum der ersten Nacht der Buchung wird hier gespeichert (wir erfassen nicht das Datum, an dem die Buchung vorgenommen wurde). *Die Tabelle '''booking''' enthält einen Eintrag für jede im Hotel vorgenommene Buchung. Eine Buchung wird von einem Gast vorgenommen - auch wenn mehr als eine Person im Hotel übernachtet, werden die Daten anderer Gäste im sel...")
  • 18:03, 5 May 2022HTL (hist | edit) ‎[317 bytes]Andr3w (talk | contribs) (Created page with "This page created for Hannes Grundschober to edit")
  • 17:11, 4 May 2022HTLWienWest/Select Basics (hist | edit) ‎[41 bytes]GRUH (talk | contribs) (Created page with "== Einführung SQL - Der SELECT Befehl ==")
  • 17:04, 4 May 2022HTLWienWest (hist | edit) ‎[34 bytes]GRUH (talk | contribs) (Created page with "== Einführung SQL HTL Wien West==")
  • 22:16, 3 May 2022Join BabySteps (hist | edit) ‎[1,159 bytes]Andr3w (talk | contribs) (Created page with "200px|thumb|left|Music database <p>This tutorial introduces the notion of a join. The music has two tables: <code>album</code> and <code>track</code> in a one-to-many relationship. </p> album('''asin''', title, artist, price, release, label, rank) track('''<i>album</i>, dsk, posn''', song) <p> <div style='clear:both'></div> <div class='qu'> Find the <code>asin</code>, <code>title</code> and <code>artist</code> for the album with title Revolv...")
  • 11:06, 3 May 2022GRUH (hist | edit) ‎[4,865 bytes]Andr3w (talk | contribs) (Created page with "==Warming up== <div class='qu'> Read the notes about this table. Observe the result of running a simple SQL command. <source lang='sql' class='def'> SELECT name, region, population FROM bbc </source> <source lang='sql' class='ans'> SELECT name, region, population FROM bbc </source> </div>")