• Post Reply Bookmark Topic Watch Topic
  • New Topic

question about aggregate function  RSS feed

 
vitesse wei
Ranch Hand
Posts: 100
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
mock question:



I think A,D are wrong,given answer is B,why C is wrong?anyone help!
 
Adam Tkaczyk
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
C) should be as follows

You can't have aggregate function inside "where" clause
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!