What version of the software am I using?

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

Unknown please help if you can

We can use a SELECT statement without specifying a table. The version() function returns details of the current implementation.

Thanks to Mark Folley

Unknown please help if you can

Meta Data

What are my tables?

What are the columns of the BBC table?

Get the first 10 rows of the gisq.cia table.

Get the 11th to the 20th rows of the cia table - by population.

What version of the software am I using?

What is the syntax to view structure of table?

How can you determine the primary key using SQL?

Return a sequential record count for all records returned