I am basically a C programmer but I started on SQL today with the only purpose of fiddling around the data available on data.stackexchange.com. So please bear with me if my question is naive or unclear. I wrote a query to find out Popular Questions on SO based on view count
Select
OwnerUserId As [User Link],
Id As [Post Link],
ViewCount As [Total Number of Views]
From
Posts
Where
ViewCount > 10000
Order By
ViewCount Desc
The problem I am facing here is if I change [Post Link]
to [Popular Question]
or [User Link]
to something more desirable like [Asker]
, the hyper-links linking to the question and the user receptively don't appear. Only IDs of users and Posts like 457237
(my user id), 145275
(this question ID) appear. If I understand correctly AS
is just an ALIAS
.
So how is that [Post Link]
produces a hyperlink and [Link to the Question]
or something else doesn't?
Is it something specific to data.stackexchange?