本文探讨了派生表与子查询之间的区别，并强调了派生表使用别名的重要性。通过具体示例展示了如何使用派生表和子查询来查询数据。
sql cast
Syntax The syntax for the CAST function is: CAST ( value AS type )
cast(click_num_str as int) as click_num
派生表需要别名，这是经常忘记的事情，需要记录和弄懂
Keep in mind that a subquery and derived tables are not the same; a derived table vs subquery comparison will show you that there are many differences between the two.
subquery
select * from tmp where a in (select a from xxx)
derived tables
select count(1) from (select * from a) as t
扫一扫
1818
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
