How to check database version in other DBs?

To check the database version in various database management systems, you can use the following commands:

1. PostgreSQL

Use the following SQL command:

SELECT version();

2. SQLite

For SQLite, you can use:

SELECT sqlite_version();

3. Oracle

In Oracle, you can check the version with:

SELECT * FROM v$version;

4. Microsoft SQL Server

For SQL Server, use:

SELECT @@VERSION;

5. MariaDB

As you already know, use:

SELECT VERSION();

Summary

Each database system has its own command to retrieve version information. Make sure to run these commands in the respective database's query interface.

If you want to dive deeper into database management, consider exploring related labs on LabEx!