Eine Einführung in
SQL
What version of the software am I using?
SQLite
Many implementations of SQL are being developed continuously and new releases are common. Usually there is a version number.
SELECT sqlite_version()
Specific to SQLite
none
DB2
Many implementations of SQL are being developed continuously and new releases are common. Usually there is a version number.
Specific to DB2
Unknown - please help if you can.
MS Access
Many implementations of SQL are being developed continuously and new releases are common. Usually there is a version number.
Specific to MS Access
none
PostgreSQL
Many implementations of SQL are being developed continuously and new releases are common. Usually there is a version number.
select version()
Specific to PostgreSQL
We can use a SELECT statement without specifying a table. The version() function returns details of the current implementation.
Oracle
Many implementations of SQL are being developed continuously and new releases are common. Usually there is a version number.
select * from v$version
Specific to Oracle
Thanks to Mark Folley
MS SQL Server
Many implementations of SQL are being developed continuously and new releases are common. Usually there is a version number.
SELECT @@version
Specific to MS SQL Server
none
MySQL
Many implementations of SQL are being developed continuously and new releases are common. Usually there is a version number.
SELECT version()
Specific to MySQL
none
Sybase
Many implementations of SQL are being developed continuously and new releases are common. Usually there is a version number.
SELECT @@version
Specific to Sybase
none
Mimer SQL
Many implementations of SQL are being developed continuously and new releases are common. Usually there is a version number.
Specific to Mimer SQL
Unknown - please help if you can.