查询的相关性 [英] Correlation of queries

查看：85 发布时间：2019/6/21 3:17:21 SQL-server-2005 SQL-Server

本文介绍了查询的相关性的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

< pre></pre>

你好，

我想知道我们如何将查询与同一表相关联.

<pre></pre>

Hello,

I would like to know how do we correlate the queries with in the same table.
Please help me in having the knowledge.

您总是可以通过使用别名来做到这一点.
例如，请参见

You can always do this by using aliases.
As an example see

SELECT name
 FROM employee AS e1
 WHERE salary > (SELECT avg(salary)
    FROM employee
    WHERE department = e1.department)

我实际上是从此获得的查询 [

I actually got the query from this[^] site, and you can read more about correlated subqueries on that web page.

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