0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

/*select count(Id) as Users from Users;
select count(Id) as Questions from Posts
where PostTypeId = 1;
select count(Id) as Answers from Posts
where PostTypeId = 2;*/

/*select * from
(select count(Id) as Users from Users)
inner join
(select count(Id) as Questions from Posts
where PostTypeId = 1)
inner join
(select count(Id) as Answers from Posts
where PostTypeId = 2)


/*select count(Users.Id) as Users
       count(Posts.Id) as Questions
       count(Posts.Id) as Answers
where PostTypeId = 1;
  
where PostTypeId = 2;*/

select top 100 Title, Body, OwnerDisplayName from Posts
where PostTypeId = 1 order by CreationDate Desc;

fork query

edited dec 10 18

created dec 10 18 anonymous