SELECT Posts.OwnerUserId, Posts.OwnerDisplayName, Posts.Id,

0

Please login or register to vote for this query.

(click on this box to dismiss)

DevOps Meta

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT
  Posts.OwnerUserId,
  Posts.OwnerDisplayName,
  Posts.Id,
  Posts.PostTypeId,
  Posts.Title,
  Users.Id,
  Users.DisplayName
FROM
  Posts
JOIN
  Users ON Posts.OwnerUserId = Users.Id
WHERE
  Posts.Title IS NOT NULL
ORDER BY
  Users.DisplayName ASC
offset 0 rows
fetch next 100 rows only;

Enter Parameters

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