练习 SQL 查询

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/3344908/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-01 06:57:52  来源:igfitidea点击:

Practice SQL Queries

sqlsql-serversql-server-2008sql-server-2005

提问by xorpower

I wanted a website that has ample amount of SQL (SQL Server 2005 or 2008) related queries to practice at home

我想要一个拥有大量 SQL(SQL Server 2005 或 2008)相关查询的网站,以便在家练习

Please let me know if you have any idea about the same.

如果您对此有任何想法,请告诉我。

thanks

谢谢

回答by Giorgi

Try this one: SQL exercises. The queries are of different difficult from easy to hardest.

试试这个:SQL 练习。查询的难度从易到难。

回答by Leniel Maccaferri

I'd suggest you to practice using Stack Exchange Data Explorer at https://data.stackexchange.com

我建议您在https://data.stackexchange.com上练习使用 Stack Exchange Data Explorer

Select a StackExchange site and click Compose Query button.

选择一个 StackExchange 站点,然后单击“撰写查询”按钮。

What is Stack Exchange Data Explorer?

Stack Exchange Data Explorer allows you to run arbitrary SQL queries on the Stack Exchange family of sites, share those queries with your friends and explore interesting queries.

什么是 Stack Exchange 数据浏览器?

Stack Exchange Data Explorer 允许您在 Stack Exchange 系列站点上运行任意 SQL 查询,与您的朋友分享这些查询并探索有趣的查询。

For more info, read the FAQ.

有关更多信息,请阅读常见问题解答

I think few people know about this great site.

我认为很少有人知道这个伟大的网站。

回答by Vidar Nordnes

Check out http://www.sqltree.com/Also, some sample databases can be found here: http://msftdbprodsamples.codeplex.com/

查看http://www.sqltree.com/此外,可以在此处找到一些示例数据库:http: //msftdbprodsamples.codeplex.com/

回答by wshato

I think you will find a wealth of material here:

我想你会在这里找到丰富的材料:

http://sqlserversamples.codeplex.com/

http://sqlserversamples.codeplex.com/

回答by user2106271

You may use http://www.compileonline.com/execute_sql_online.phpto execute your queries online.

您可以使用http://www.compileonline.com/execute_sql_online.php在线执行您的查询。

Hope this helps.

希望这可以帮助。