Member Avatar for saadi06

Hi,
I am having a problem in building a query.I want to get first 10 users that has 1000 positive feedback my table structure is something like this
id(primary key) userid(name of the user) raterid(name of the rater) rate_type(type of rating for example +ve,-ve or neutral).I have used many queries but it is not working can anyone help.
Thanks in advance

  • 2 Contributors
  • 1 Reply
  • 61 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by karthik_ppts
Member Avatar for karthik_ppts

check out this query

select userid,count(rate_type) as cnt from tbl_name where cnt>1000 and rate_type='+ve' group by userid limit 0,10

Note:Query is not tested

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.