MulaiMulai sekarang secara gratis

Insert

This exercise consists of two parts: In the first, you'll create a new table very similar to the one you created in the previous interactive exercise. After that, you'll insert some data and retrieve it.

You'll continue working with the Chinook database here.

Latihan ini adalah bagian dari kursus

Introduction to SQL Server

Lihat Kursus

Latihan interaktif praktis

Cobalah latihan ini dengan menyelesaikan kode contoh berikut.

-- Create the table
CREATE TABLE tracks(
	-- Create track column
	___ ___(200),
    -- Create album column
  	___ ___(160),
	-- Create track_length_mins column
	___ ___
);
-- Select all columns from the new table
SELECT 
  * 
FROM 
  ___;
Edit dan Jalankan Kode