主查询中是否可以用数字引用相应的列??

Question

SELECT [1],[2],[3],dbo.fnAbc(4) from(
    selct * from myTest
)

表myTest有tID,tName,tA,tB,tC列

这样查询不可以?

Answer 1

SELECT [1],[2],[3],dbo.fnAbc(4) from(
    selct * from myTest
) a

Answer 2

不可以, 仅 ORDER BY 中支持

Answer 3

我试了不行！

Answer 4

SELECT [1],[2],[3],dbo.fnAbc(4) from(
    selct * from myTest
)

表myTest有tID,tName,tA,tB,tC列

这样查询不可以?

1、不支持这样，在order by子句可以这样
2、变通一下
select [1],[2],[3],dbo.fnabc([4])
from
(
     select tid as [1],tname as [2] ,ta as [3],tb as [4],tc as [5] from mytest
) a

如果这样可以接受　，那把你的mytest做一个视图出来v_mytest，以后可以直接引用

---

More: blog.csdn.net/happyflystone

Answer 5

这种查询在pivot中是可以的

---

Memory all alone in the moonlight~My Blog in .NET~~~