*select count(*) from ( * * SELECT loyalty_id FROM transactions GROUP BY loyalty_id HAVING COUNT(*)>1 * *) as t *
problem when writing the corresponding rails queries...? I am using * Rails2.3.11* Also this have error *select sum(points) from transactions where transaction_type ="new_customer" or transaction_type= "review" or transaction_type= "purchase" . * * * *I tried like this Transaction.find(:id => :conditions =>["transaction_type = ? OR transaction_type = ? OR transaction_type = ?", ctype, ctype1,ctype2]).sum("points"). but it shows some ID error* * * *Thnk you* *vishnu* -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/pcWTdVnyRQ0J. To post to this group, send email to rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.