Mysql Join with limit? -

-

I have a table with category, product and count all the integers I'm looking for the most efficient query which I Give the top 10 products (highest count) for the category.

I have tried many sub-genres but it did not know how to do this thanks to your help in the same query. 

  * From one to 10 & gt; (Select calculation (*) from TB, where BC range = C. range and bacant & lt; a.count)

I think this is what you need.


Comments

Post a Comment

Popular posts from this blog

c# - PInvoke of NetUserAdd returns 24 -

-
I am calling NetUserAdd and it is returning 24 for each call. Does anyone know 24 stands for? When I do not know what the error is, it is very difficult to debug it. I'm calling it a Windows XP machine running as a local administrator. I am also a local administrator on the target computer. I tried to do it with USER_INFO_1 and it worked fine. I need a level of control given by USER_INFO_2. This shows the return value for this call. They are further defined by numeric values. Unfortunately none of these values ​​= 24 I know this is a very specific question. I think I'm hoping to find a PInvoke / NetAddUser expert who can help me out there Here in case my code matters. [StructLayout (LayoutKind., Choracet = charset.unycode)] Public structure USER_INFO_2 {name of the public string; Public string password; Public int password_age; Public entities Private; Public string home_dir; Public string comment; Public integer flags; Public string script_path; Public int auth_...
Read more

actionscript 2 - getURL action script 2 and IE 7/8 -

-
I have many flash movies that need to be redirected to an external website at the end of the presentation. In any browser (Firefox, Opera, etc.), getURL (""); Works but in IE version 7 and 8, it's just hanging. I need to use Action Script 2 because I have many codes that do not work in AS3. Thank you! Hm. I have not touched AS2 in at least one year, but I have to remember that this is an issue ... I think it is IE's security settings, do you have local form Running this SWF from? You may want to read them:
Read more