当前位置: 首页 > 网络学院 > 服务端脚本教程 > SQL > SQL 技能测试
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表格的一个子集。
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 |
SELECT * FROM customers |
SELECT CompanyName, ContactName |