IniziaInizia gratis

Simple selections

It's time to begin writing your own queries! In this first coding exercise, you will use SELECT statements to retrieve columns from a database table. You'll be working with the eurovision table, which contains data relating to individual country performance at the Eurovision Song Contest from 1998 to 2012.

After selecting columns, you'll also practice renaming columns, and limiting the number of rows returned.

Questo esercizio fa parte del corso

Introduction to SQL Server

Visualizza il corso

Esercizio pratico interattivo

Prova a risolvere questo esercizio completando il codice di esempio.

-- SELECT the country column FROM the eurovision table
___ 
  country
___ 
  eurovision;
Modifica ed esegui il codice