What are the challenges you face when working across database platforms? Take the survey
Options

Additional Columns Listed in "Press TAB to expand wildcards"

JoshRossJoshRoss Posts: 4 Bronze 1
edited March 1, 2018 4:34PM in SQL Prompt
WITH some_dumb_data AS (

SELECT id,SUM(items)/pack_size AS foo
FROM (VALUES(1,1,1)) v(id,items,pack_size)
GROUP BY id,v.pack_size

)

SELECT *
FROM some_dumb_data

if I tab after the *, I get pack_size in the column list, although it is not in the CTE.

Answers

Sign In or Register to comment.