Questions tagged only 'sql'

0

Please login or register to vote for this query.

(click on this box to dismiss)

Database Administrators

Q&A for database professionals who wish to improve their database skills and learn from others in the community

SELECT
    [Row Number] =
      ROW_NUMBER() OVER (
          ORDER BY
              P.LastActivityDate ASC,
              P.Id ASC),
    [Post Link] = P.Id,
    P.Title,
    P.Score,
    P.ViewCount,
    P.AnswerCount,
    P.ClosedDate,
    P.LastActivityDate
FROM dbo.Posts AS P
WHERE
    P.Tags = N'<sql>'
ORDER BY
    P.LastActivityDate ASC,
    P.Id ASC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results