M
M
Mikhail Mashkantsev2021-04-10 21:02:31
SQL
Mikhail Mashkantsev, 2021-04-10 21:02:31

What does the symbol t mean in this query?

select max(cnt) from (select count(recruitmental_id) as cnt from recruitment_for_the_program group by program_id) t
I'm guessing t is an abbreviation for the table name, but I haven't seen it assigned. Perhaps the matter is in cnt, which, in theory, is just a name too. Please clarify

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Sergey Gornostaev, 2021-04-10
@ Michael_29

t is short for expression as tthat assigns a name to the result of the subquery.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question