I think you are looking for TOP10, TOP20 or TOP100 function. This feature is not supported directly in MapInfo, but you can get there if you do like this:
Start by doing your normal group query (note the special Order By section) Select Columns: Province, Type, Sub_Type, Count(*) "COUNT" >From Tables: National_Health_Facility_List_ Group By Columns: Province, Type, Sub_Type Order By Columns: COUNT Desc into Table Named: Count_Test Now we do a query were we only take the first 20 records from the previous result: Select Columns: * >From Tables: Count_Test Where: ROWID <= 20 Group By Columns: Order By Columns: COUNT Desc into Table Named: Count_Test_TOP20 But this is not the correct way, so you might see strange things... Peter Horsbøll Møller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk *****CHANGE OF ADDRESS - COWI's offices in Odense are now under the same roof***** On December 8th. 2003, Geographical Information & IT moved from Rugaardsvej 55, 5000 Odense C to Odensevej 95, 5260 Odense S. Please note our new telephone, direct and telefax numbers. > -----Original Message----- > From: Norman Mabunda [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 15, 2004 8:45 AM > To: Peter Horsbøll Møller; [EMAIL PROTECTED] > Subject: RE: MI-L SQL Query > > > Thanx Peter > > Another question: Is't possible 1000 records count to see > only a certail number of records. For instance, of the 100 > records count, to see the 1st 20 records, or to see only 20 > records of the 100 records. If yes, how? > > Regards, > > > >>> Peter Horsbøll Møller <[EMAIL PROTECTED]> 01/15/04 09:34AM >>> > The Count(*) aggregation is bound to the Group By section of > the query: > > Ex 1: > Select Columns: Province, Type, Sub_Type, Count(*) "COUNT" > From Tables: National_Health_Facility_List_ > Group By Columns: Province, Type, Sub_Type > Order By Columns: > into Table Named: Count_Test > > Result: Here you get a list that looks like this: > Province, Type, Sub_Type, COUNT > What it tells you is how many records there is for each > combnation of Province, Type and Sub_Type > > Ex 2: > Select Columns: Province, Count(*) "COUNT" > From Tables: National_Health_Facility_List_ > Group By Columns: Province > Order By Columns: > into Table Named: Province_Count_Test > > Result: Here you get a list that looks like this: > Province, COUNT > What it tells you is how many records there is for each > combnation of Province > > It is the Group By section that defines what you are actually > counting. Also have in mind that you almost never should have > other columns in the Select Columns sections that those > mentioned in the Group By section. > > Peter Horsbøll Møller > GIS Developer > Geographical Information & IT > > COWI A/S > Odensevej 95 > DK-5260 Odense S > Denmark > > Tel +45 6311 4900 > Direct +45 6311 4908 > Mob +45 5156 1045 > Fax +45 6311 4949 > E-mail [EMAIL PROTECTED] > http://www.cowi.dk > > *****CHANGE OF ADDRESS - COWI's offices in Odense are now > under the same roof***** On December 8th. 2003, Geographical > Information & IT moved from Rugaardsvej 55, 5000 Odense C to > Odensevej 95, 5260 Odense S. > Please note our new telephone, direct and telefax numbers. > > > > > -----Original Message----- > > From: Norman Mabunda [mailto:[EMAIL PROTECTED] > > Sent: Thursday, January 15, 2004 8:14 AM > > To: [EMAIL PROTECTED]; > > [EMAIL PROTECTED]; > [EMAIL PROTECTED] > > Subject: Re: MI-L SQL Query > > > > > > I have a table that I wanted to do a similiar thing to what > > Andrew Tracey wanted to do. > > > > Please see the attachment to see what I did: > > > > Select Columns: Province, Type, Count(Sub_Type) "5" > > > > From Tables: National_Health_Facility_List_ > > > > Where Condition: > > > > Group By Columns: Sub_Type > > > > Order By Columns: > > > > into Table Named: Count_Test > > > > MI does not want any field name other than * within the Count > > brackets. When I put "Count(*)" and then "5" after that, 5 > > becomes a count field name, not the number of records I need > > a count for. > > > > Now the question is: Do we always have to get the count of > > all the records, not the number of records we want to see? If > > the answer is no, then how do we do it? > > > > Regards, > > > > > > > > > > > > > > > > >>> "Steve Kalmbach" <[EMAIL PROTECTED]> 01/14/04 08:38PM >>> > > Yes, the query would go something like this: > > > > Select WARD_NO, TENURE_TYPE, Count(TENTURE_TYPE) "How_Many" > > From MY_TABLE GROUP BY WARD_NO, TENURE_TYPE ORDER BY WARD_NO, > > TENURE_TYPE Into RESULTS_TABLE > > > > If you are using the SQL select dialog, the first line above > > is the 'Select Columns', the second line is the 'from > > Tables', the third line is the 'Group by Columns', and the > > fourth line is the 'Order by Columns'. > > > > > > Steve Kalmbach > > Systems Department > > The Grand Rapids Press > > 616-222-5498 > > [EMAIL PROTECTED] > > > > > > >>> "Andrew Tracey" <[EMAIL PROTECTED]> 01/14/2004 > > 11:50:06 AM >>> > > Dear All > > > > I have a MapInfo table which comprises ward reference no and > > tenure type. I am trying to produce a query that will list > > the 20 wards and a count of how many of each tenure type > > there are in each ward. I want one browser with all results > > on. Is this possible. > > > > Thanks in advance > > Andrew Tracey > > Information Support Officer > > Corporate Information > > Corporate Growth and Focus > > Corporate Development > > South Tyneside Council > > Westoe Road > > South Shields > > NE33 2RL > > > > Tel: 0191 4247561 > > E-Mail : [EMAIL PROTECTED] > > ************************************************************** > > ********************************** > > Please do not print this e-mail if you can help it - and help > > protect the environment. > > ************************************************************** > > ********************************** > > This Message may contain confidential information and is > > protected by copyright. If you receive it in error please > > notify us and delete it without making use of or copying it. > > The addressee and other employees within the Council may read > > and copy any e-mail reply to this message and other e-mails > > you send to us. Whilst we use virus checking procedures we > > accept no liability for viruses and recipients > > must rely on their own virus checking procedures. > > ************************************************************** > > ********************************** > > The Council's web site address is www.southtyneside.info > > > > > --------------------------------------------------------------------- > > List hosting provided by Directions Magazine | > > www.directionsmag.com | To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > Message number: 9883 > > > > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9896