请问from语句后面带个t是什么意思?

来源：百度知道 编辑：UC知道 时间：2024/06/15 18:35:21
select top 1 [name],[pass] from user group by [name],[pass] order by [pass]) t order by [pass] desc,[name] desc
可以详细点吗?

t表示给表起个别名的意思

应该是select top 1 [name],[pass] from (user group by [name],[pass] order by [pass]) t order by [pass] desc,[name] desc吧,少了括号,起个别名是不是就相当于赋变量差不多,楼上的,解释下!