Difference between revisions of "What version of the software am I using?"
From SQLZOO
| (One intermediate revision by one user not shown) | |||
| Line 6: | Line 6: | ||
<source lang=sql class='tidy'> | <source lang=sql class='tidy'> | ||
</source> | </source> | ||
| + | <source lang=sql class='setup'></source> | ||
<source lang='sql' class='def e-sqlite'>SELECT sqlite_version() | <source lang='sql' class='def e-sqlite'>SELECT sqlite_version() | ||
</source> | </source> | ||
| − | <source lang='sql' class='def e- | + | <source lang='sql' class='def e-postgres'>select version() |
</source> | </source> | ||
<source lang='sql' class='def e-oracle'>select * from v$version | <source lang='sql' class='def e-oracle'>select * from v$version | ||
Latest revision as of 14:13, 12 July 2012
What version of the software am I using?
Many implementations of SQL are being developed continuously and new releases are common. Usually there is a version number.
SELECT sqlite_version()
SELECT version()
SELECT * FROM v$version
SELECT @@versionSELECT version()
SELECT @@versionWhat version of the software am I using?
