On this page you can test your SQL skills. 在这张页面你可以测试你的SQL技能
We will use the Customers table in the Northwind database: 我们将使用Northwind数据库中的Customers表:
CompanyName
ContactName
Address
City
Alfreds Futterkiste
Maria Anders
Obere Str. 57
Berlin
Berglunds snabbköp
Christina Berglund
Berguvsvägen 8
Luleå
Centro comercial Moctezuma
Francisco Chang
Sierras de Granada 9993
México D.F.
Ernst Handel
Roland Mendel
Kirchgasse 6
Graz
FISSA Fabrica Inter. Salchichas S.A.
Diego Roel
C/ Moralzarzal, 86
Madrid
Galería del gastrónomo
Eduardo Saavedra
Rambla de Cataluña, 23
Barcelona
Island Trading
Helen Bennett
Garden House Crowther Way
Cowes
Königlich Essen
Philip Cramer
Maubelstr. 90
Brandenburg
Laughing Bacchus Wine Cellars
Yoshi Tannamuri
1900 Oak St.
Vancouver
Magazzini Alimentari Riuniti
Giovanni Rovelli
Via Ludovico il Moro 22
Bergamo
North/South
Simon Crowther
South House 300 Queensbridge
London
Paris spécialités
Marie Bertrand
265, boulevard Charonne
Paris
Rattlesnake Canyon Grocery
Paula Wilson
2817 Milton Dr.
Albuquerque
Simons bistro
Jytte Petersen
Vinbæltet 34
København
The Big Cheese
Liz Nixon
89 Jefferson Way Suite 2
Portland
Vaffeljernet
Palle Ibsen
Smagsløget 45
Århus
Wolski Zajazd
Zbyszek Piestrzeniewicz
ul. Filtrowa 68
Warszawa
To preserve space, the table above is a subset of the Customers table used in the example below. 为了节约空间,上述表格是下面例子所使用的Customers表格的一个子集。
Try it Yourself 自己试一试吧
To see how SQL works, you can copy the SQL statements below and paste them into the textarea, or you can make your own SQL statements. 为了使你明白SQL是如何工作的,你可以将下面的SQL语句复制到文本框内,或者你可以书写你自己的SQL语句。
SELECT * FROM customers
SELECT CompanyName, ContactName FROM customers
SELECT * FROM customers WHERE companyname LIKE 'a%'
SELECT CompanyName, ContactName FROM customers WHERE CompanyName > 'g' AND ContactName > 'g'
Test your SQL Skills测试你的SQL技能On this page you can test your SQL skills.在这张页面你可以测试你的SQL技能We will use the Customers table in the Northwind database:我们将使用Northwind数据库中的Customers表: