mySQL HAVING, GROUP BY - условие к GROUP BY, пример SQL запроса. Условие на группу

Primary tabs

vedro-compota's picture
Submitted by vedro-compota on Mon, 04/04/2016 - 15:36

Forums:

Такой пример:

SELECT user_id, user_name, SUM(r_count) AS recalls_count
 FROM user_settings WHERE (noindex = 0)  GROUP BY user_id   
  HAVING (recalls_count > 0) 
	ORDER BY user_id LIMIT 400 , 2000

Key Words for FKN + antitotal forum (CS VSU):

  • Log in to post comments
  • 2235 reads