Is there a way to call and use the newly created column right away when selecting in mssql?

select T.test_col
        ,MAX(T.test_co) as max_test
        ,max_test as max2 -- I want to use the column information that I calculated earlier like this right away.
from test_table T

Is it completely impossible? Or can I use it through the join door?

sql mssql database

2022-09-20 21:47

1 Answers

You can use WITH section and there are many ways, but if you really want to select the query as you posted, you can just use Subquery.

SELECT
    T_T.test_col,
    T_T.max_test AS max2
FROM (
    SELECT
        T.test_col,
        max(T.text_co) AS max_test
    FROM test_table T
) T_T

2022-09-20 21:47

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656