T-SQL - 什么是内联视图? [英] T-SQL - What is an inline-view?

问题描述

我最近回答了这个问题 how-to-call-user-defined-function-in-order-to-use-with-select-group-by-order-by

I recently answered this question how-to-call-user-defined-function-in-order-to-use-with-select-group-by-order-by

我的回答是使用内联视图来执行该功能，然后对其进行分组.

My answer was to use an inline view to perform the function and then group on that.

在评论中提问者没有理解我的回答，并要求提供一些网站/参考资料来帮助解释.

In comments the asker has not understood my response and has asked for some sites / references to help explain it.

我在谷歌上做了一个快速的搜索，但没有找到任何很好的资源来详细解释内联视图是什么以及它们的用处.

I've done a quick google and haven't found any great resources that explain in detail what an inline view is and where they are useful.

有没有人可以帮助解释内联视图是什么?

Does anyone have anything that can help to explain what an inline view is?

推荐答案

来自这里:内联视图是另一个 SELECT 语句的 FROM 子句中的 SELECT 语句.内嵌视图通常用于通过删除连接操作并将多个单独的查询压缩为单个查询来简化复杂的查询.

From here: An inline view is a SELECT statement in the FROM-clause of another SELECT statement. In-line views are commonly used simplify complex queries by removing join operations and condensing several separate queries into a single query.

这篇关于T-SQL - 什么是内联视图?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！