{"id":418,"date":"2012-09-23T22:48:13","date_gmt":"2012-09-23T17:18:13","guid":{"rendered":"https:\/\/www.psoftsearch.com\/interview-questions\/?p=418"},"modified":"2012-09-23T22:49:14","modified_gmt":"2012-09-23T17:19:14","slug":"aggregate-functions-and-group-by-clause","status":"publish","type":"post","link":"https:\/\/www.psoftsearch.com\/interview-questions\/aggregate-functions-and-group-by-clause\/","title":{"rendered":"Aggregate functions and Group by Clause"},"content":{"rendered":"<p>You would have written some SQL statements for sure that has an aggregate function followed by some sort of group by clause. Is it always necessary for an aggregate function to have a group by clause?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You would have written some SQL statements for sure that has an aggregate function followed by some sort of group by clause. Is it always necessary for an aggregate function to have a group by clause?<\/p>\n","protected":false},"author":18,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[27],"tags":[],"_links":{"self":[{"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/posts\/418"}],"collection":[{"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=418"}],"version-history":[{"count":2,"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/posts\/418\/revisions"}],"predecessor-version":[{"id":420,"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/posts\/418\/revisions\/420"}],"wp:attachment":[{"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=418"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=418"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}