SQL Server 2005查询 [英] SQL Server 2005 Queries

问题描述

我需要练习sql查询，以改善我进行查询和进行面试时的逻辑.


因此，请从哪里可以获取sql服务器查询分配，以便我可以解决这些查询.

谢谢与问候，
我建议您，而不是要求某人给您家庭作业，然后您将学习，而从基础开始学习.像
1.什么是Join
2.联接的类型是什么
3.如何使用它们
4.何时使用哪个连接
5. ON子句和Where子句有什么区别.
6.什么是Group by子句，having子句，何时使用where和having等.

这只是一个简单的清单.使用SQL您可以做很多事情.

作为开始参考，您可以参考:
1. 最佳入门教程 [高级主题 [关于联接的好教程 [来自MSDN的一个 [ http://www.itl.nist.gov/div897/ctg/dm/sql_examples. htm [ ^ ]

解决方案

I suggest you, instead of asking someone to give you homework and then you will learn, you start studying from the basics. Like
1. what is Join
2. what are the types of Joins
3. How to use them
4. When to use which join
5. What is the difference between ON clause and Where clause.
6. What is Group by clause, having clause, when to use where and having etc.

This is just a simple list. There is a lot you can do with SQL.

As as starting reference you can refer to :
1. Best starting tutorial[^]
2. A bit advanced topics[^]
3. A good tutorial on joins[^]
4. One from MSDN[^]

If you want to start with examples only then refer :
1. http://www.itl.nist.gov/div897/ctg/dm/sql_examples.htm[^]

Google[^] is always a good place to start: have a look at the fourth link for starters!

这篇关于SQL Server 2005查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！