http://sqlzoo.net/w/index.php?title=What_version_of_the_software_am_I_using%3F&feed=atom&action=historyWhat version of the software am I using? - Revision history2013-05-21T14:10:32ZRevision history for this page on the wikiMediaWiki 1.20.4http://sqlzoo.net/w/index.php?title=What_version_of_the_software_am_I_using%3F&diff=1084&oldid=prevConnor at 14:13, 12 July 20122012-07-12T14:13:35Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 14:13, 12 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 6:</td>
<td colspan="2" class="diff-lineno">Line 6:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang=sql class='tidy'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang=sql class='tidy'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"><source lang=sql class='setup'></source></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlite'>SELECT sqlite_version()</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlite'>SELECT sqlite_version()</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
</table>Connorhttp://sqlzoo.net/w/index.php?title=What_version_of_the_software_am_I_using%3F&diff=993&oldid=prevConnor at 08:19, 12 July 20122012-07-12T08:19:50Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 08:19, 12 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 8:</td>
<td colspan="2" class="diff-lineno">Line 8:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlite'>SELECT sqlite_version()</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlite'>SELECT sqlite_version()</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><source lang='sql' class='def e-<del class="diffchange diffchange-inline">postgresql</del>'>select version()</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang='sql' class='def e-<ins class="diffchange diffchange-inline">postgres</ins>'>select version()</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle'>select * from v$version</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle'>select * from v$version</div></td></tr>
</table>Connorhttp://sqlzoo.net/w/index.php?title=What_version_of_the_software_am_I_using%3F&diff=992&oldid=prevConnor at 08:19, 12 July 20122012-07-12T08:19:30Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 08:19, 12 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 8:</td>
<td colspan="2" class="diff-lineno">Line 8:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlite'>SELECT sqlite_version()</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlite'>SELECT sqlite_version()</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><source lang='sql' class='def e-<del class="diffchange diffchange-inline">postgres</del>'>select version()</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang='sql' class='def e-<ins class="diffchange diffchange-inline">postgresql</ins>'>select version()</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle'>select * from v$version</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle'>select * from v$version</div></td></tr>
</table>Connorhttp://sqlzoo.net/w/index.php?title=What_version_of_the_software_am_I_using%3F&diff=910&oldid=prevConnor: Created page with "What version of the software am I using? <div class='ht'> <div> Many implementations of SQL are being developed continuously and new releases are common. Usually there is a ve..."2012-07-11T15:39:41Z<p>Created page with "What version of the software am I using? <div class='ht'> <div> Many implementations of SQL are being developed continuously and new releases are common. Usually there is a ve..."</p>
<p><b>New page</b></p><div>What version of the software am I using?<br />
<div class='ht'><br />
<div><br />
Many implementations of SQL are being developed continuously and new releases are common. Usually there is a version number.<br />
</div><br />
<source lang=sql class='tidy'><br />
</source><br />
<source lang='sql' class='def e-sqlite'>SELECT sqlite_version()<br />
</source><br />
<source lang='sql' class='def e-postgres'>select version()<br />
</source><br />
<source lang='sql' class='def e-oracle'>select * from v$version<br />
</source><br />
<source lang='sql' class='def e-sqlserver'>SELECT @@version<br />
</source><br />
<source lang='sql' class='def e-mysql'>SELECT version()<br />
</source><br />
<source lang='sql' class='def e-sybase'>SELECT @@version<br />
</source><br />
<div class="ecomm e-db2" style="display: none">Unknown please help if you can</div><br />
<div class="ecomm e-postgres" style="display: none">We can use a SELECT statement without specifying a table. The version() function returns details of the current implementation.</div><br />
<div class="ecomm e-oracle" style="display: none">Thanks to Mark Folley</div><br />
<div class="ecomm e-mimer" style="display: none">Unknown please help if you can</div><br />
</div><br />
{{Meta Data ref}}</div>Connor