Oracle
===
SELECT * FROM V$VERSION

PostgreSQL
===
SELECT version();
OR
psql --version

SQL Server
===
SELECT @@VERSION

MySQL
===
SELECT version();
OR
SELECT @@version;