SELECT TOP ##TopCount:INT?100## -- optional 100 ROW_NU...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT 

    TOP ##TopCount:INT?100## -- optional 100


    ROW_NUMBER() OVER (ORDER BY p.CreationDate ASC) AS 'ID',
    p.Id AS [Post Link],
    --p.PostTypeId AS TID,
    p.Id AS PID,
    p.OwnerUserId AS UID,
    p.CreationDate AS Created
    
FROM Posts AS p

WHERE p.PostTypeId = 1
AND YEAR(p.CreationDate) = 2008
AND p.Tags LIKE '%<vba>%'

ORDER BY p.CreationDate ASC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results