只需select idnum, sk, f, e, h, 'F'||SK as col_name ...您需要指定所有列而不是星号.

Just select idnum, sk, f, e, h, 'F'||SK as col_name ... You need to specify all columns instead of an asterix.

类似 http://sqlfiddle.com/#!4/12446/21