Difference between revisions of "What version of the software am I using?"

From SQLZOO
Jump to: navigation, search
 
Line 13: Line 13:
 
<source lang='sql' class='def e-oracle'>select * from v$version
 
<source lang='sql' class='def e-oracle'>select * from v$version
 
</source>
 
</source>
<source lang='sql' class='def e-sqlserver'>SELECT @@version
+
<source lang='sql' class='def e-mssql'>SELECT @@version
 
</source>
 
</source>
 
<source lang='sql' class='def e-mysql'>SELECT version()
 
<source lang='sql' class='def e-mysql'>SELECT version()

Latest revision as of 17:26, 1 July 2017

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 @@version
SELECT version()
SELECT @@version