query 1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Engineering

Q&A for professionals and students of engineering

--select * from posts where commentCount>150
--select max(commentCount) from posts 
--select answerCount from posts group by answercount
--having count(AnswerCount) >1
--select distinct answercount from posts 
--where answercount in ()

--select count(answerCount) from posts 
--where answerCount in (select distinct answercount from posts)

/*SELECT * from 
       (select answerCount,count(id) AS numberOfRecords 
        FROM posts
        where answerCount is not null
        Group BY answerCount) as M
where numberOfRecords >1
ORDER BY answerCount */

--select count(id) from posts --where answercount=13

select postid, score,Text 
from Comments
where score in (select max(score) from comments)

--select postId,score from comments where score=1424

Enter Parameters

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