sql - Select * from subquery - Stack Overflow

2012年1月18日 - You can select every column from that sub-query by aliasing it and adding the alias before the * : SELECT t.*, a+b AS total_sum FROM ( SELECT ...

stackoverflow.com