question 4

0

Please login or register to vote for this query.

(click on this box to dismiss)

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

/* Getting the percentage of posts that have no comments
just used subqueries in the select statement*/

Select
cast((select count(*) from posts where commentcount = 0) as float)/cast((select count(*) from posts) as float) *100 as percent_without_comments
;

Enter Parameters

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