• Examples
  • Sample Database
#1
SELECT
	trackid,
	name,
	mediatypeid
FROM
	tracks
WHERE
	mediatypeid IN (1, 2)
ORDER BY
	name ASC;
#2
SELECT
	trackid,
	name,
	MediaTypeId
FROM
	tracks
WHERE
	mediatypeid = 1 OR mediatypeid = 2
ORDER BY
	name ASC;
#3
SELECT
	albumid
FROM
	albums
WHERE
	artistid = 12;
#4
SELECT
	trackid,
	name,
	albumid
FROM
	tracks
WHERE
	albumid IN (
		SELECT
			albumid
		FROM
			albums
		WHERE
			artistid = 12
	);
#5
SELECT
	trackid,
	name,
	genreid
FROM
	tracks
WHERE
	genreid NOT IN (1, 2,3);
albums artists customers employees genres invoice_items invoices media_types playlist_track playlists tracks
  • SQL Query
Enter a query, then click the execute button or press F9 to run it.
  • Result
Loading