0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for ebook publishers and readers

SELECT TOP 100
    'https://travel.stackexchange.com/questions/' + CONVERT(VARCHAR, Posts.Id) as url,
    Title,
    ViewCount,
    Score,
    CreationDate
FROM Posts 
WHERE Posts.PostTypeId = 1;

view current version

edited dec 6

created dec 6 anonymous