0 votes 0 votes Why here C is invalid?? Niharika 1 asked Nov 20, 2017 Niharika 1 251 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes Every group attribute ,must present in select clause. here "year" is not present in select clause Akash Mittal answered Nov 20, 2017 Akash Mittal comment Share Follow See all 4 Comments See all 4 4 Comments reply Niharika 1 commented Nov 20, 2017 reply Follow Share Is there any such rules other than this?? 0 votes 0 votes Akash Mittal commented Nov 20, 2017 reply Follow Share yes, aggregate function like avg, count etc may present alongside the attributes 0 votes 0 votes Niharika 1 commented Nov 20, 2017 reply Follow Share So Select should contain what all the column names present in Group clause along with Aggregate functions?? Is it right?? 0 votes 0 votes Akash Mittal commented Nov 20, 2017 reply Follow Share depends upon query, aggregate function may/may not be present but every attribute which is in group clause must be in select clause 0 votes 0 votes Please log in or register to add a comment.