The Ultimate Guide to High Availability with MariaDB

Comments - subquery in FROM clause not working

1 year, 1 month ago Ahmed Haroon
Re: subquery in FROM clause not working [Answer]

its working fine now, just formatted and added alias to subquery as below:

SELECT applicant_id FROM (SELECT applicant_id, COUNT(*) nn FROM memberships WHERE memberships.status = 'Active' GROUP BY applicant_id HAVING COUNT(*)>1) t

regards

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.