0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for active researchers, academics and students of physics

SELECT TOP 10 
    Users.Id AS UserId,               -- Уникальный идентификатор пользователя
    Users.DisplayName AS UserName,    -- Имя пользователя
    Users.CreationDate AS JoinDate    -- Дата регистрации пользователя
FROM 
    Users
LEFT JOIN 
    Posts
ON 
    Users.Id = Posts.OwnerUserId
WHERE 
    Posts.Id IS NULL; -- Условие: пользователь не создал ни одного поста

view current version

edited dec 4

created dec 3 jon.doe46476