sql 语句with table as () select * from table

Question

例如：with t_rowtable
as
(
select row_number() over(order by Age) as [Row Number by Age],* from Person
)
select [Row Number by Age],FirstName,Age from t_rowtable where [Row Number by Age]>1 and [Row Number by Age]< 4 order by Agewith table as () select * from table 这语句具体是干嘛的呢？

Answer 1

查询 表中年龄2-3 的 姓名，年龄

Answer 2

百度一下 sql with as，有with as用法的详细介绍，学习体会一下吧，希望对你有所帮助。