SQLite MIN: Examples

SELECT
	min(Milliseconds)
FROM
	tracks;

SELECT
	trackid,
	name,
	milliseconds
FROM
	tracks
WHERE
	milliseconds = (
		SELECT
			min(Milliseconds)
		FROM
			tracks
	);

SELECT
	albumid,
	min(milliseconds)
FROM
	tracks
GROUP BY
	albumid;

SELECT
	albumid,
	min(milliseconds)
FROM
	tracks
GROUP BY
	albumid
HAVING
	MIN(milliseconds) < 10000;

SELECT * FROM albums;

SELECT * FROM artists;

SELECT * FROM customers;

SELECT * FROM employees;

SELECT * FROM genres;

SELECT * FROM invoice_items;

SELECT * FROM invoices;

SELECT * FROM media_types;

SELECT * FROM playlist_track;

SELECT * FROM playlists;

SELECT * FROM tracks;

Execute

Clear Beautify Minify

Reload