How to name an output column in the SQLite VALUES clause?

If I run this query in sqlite3(3.17.0)

select T.* from (values ​​(1 ),(2),(3),(4),(5)) as T;

I get the following output, where there is no name of the first column of T.

----------
1
2
3
4
5

How to Give a name/alias to the first column of T, or, is there a way to refer to it in some way through the index?

with cte(my_column_alias) as 
(select * from (values ​​( 1),(2),(3),(4),(5)))
select * from cte;

If I am in sqlite3(3.17 .0) Run this query in

select T.* from (values ​​(1),(2),(3),(4),(5) ) as T;

I get the following output, where there is no name of the first column of T.

---------- 
1
2
3
4
5

How to name/alias the first column of T, or, is there a way to pass the index Cite it somehow?

with cte(my_column_alias) as 
(select * from (values ​​(1),(2),(3),( 4),(5)))
select * from cte;

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 933 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.