Use Alias as argument in subqueries sql server

Smoggy Shrew answered on July 17, 2022 Popularity 5/10 Helpfulness 1/10

answer Use Alias as argument in subqueries sql server

Comment

SELECT * FROM (SELECT uid, COUNT(*) AS count FROM my_table GROUP BY 1 ORDER BY 2) AS x LIMIT 1;

Popularity 5/10 Helpfulness 1/10 Language sql

Source: pganalyze.com

Tags: alias sql sql-server

Link to this answer
Share Copy Link

Contributed on Jul 17 2022

Smoggy Shrew

0 Answers Avg Quality 2/10

Oops, You will need to install Grepper and log-in to perform this action.