Bookmark this page: Add How to display MapInfo SQL rows from a Select Count When the count is greater than 1 to Yahoo MyWeb Add How to display MapInfo SQL rows from a Select Count When the count is greater than 1 to Google Bookmarks Add How to display MapInfo SQL rows from a Select Count When the count is greater than 1 to Windows Live Add How to display MapInfo SQL rows from a Select Count When the count is greater than 1 to Del.icio.us Digg How to display MapInfo SQL rows from a Select Count When the count is greater than 1! Add How to display MapInfo SQL rows from a Select Count When the count is greater than 1 to Netscape
  •  
  • Subject
  • Author
  • Date
If you were  Registered and logged in, you could reply and use other advanced thread options
Posted by relms on September 10, 2008, 9:00 pm


Using the SQL Select function in MapInfo Professional ... I'm wanting
to display only those rows return from the statement
"Count(*),Unique_ID" ... In the Select Columns: box ... When the
resulting count is greater than 1 ... In the return browser.

Would anyone like to assist in what is required ... I was guessing a
statement in the Where Condiction: box ... Like [Count(*),Unique_ID >
"1"] ... But I getting the syntax error message "Variable or Field
Count not defined".

I'm just starting to learn ... But still need to learn a lot more ...
And self teaching from Google is never the easiest method at the best
of times ... But I=92d like to feel that it's a good place to look for
HELP!

Posted by Uffe Kousgaard on September 11, 2008, 1:55 am


> Using the SQL Select function in MapInfo Professional ... I'm wanting
> to display only those rows return from the statement
> "Count(*),Unique_ID" ... In the Select Columns: box ... When the
> resulting count is greater than 1 ... In the return browser.

> Would anyone like to assist in what is required ... I was guessing a
> "1"] ... But I getting the syntax error message "Variable or Field
> Count not defined".

You have to do it in 2 steps:

select field,count(*) from table group by field into tmp

select * from tmp where col2>1

> I'm just starting to learn ... But still need to learn a lot more ...
> And self teaching from Google is never the easiest method at the best
> of times ... But I'd like to feel that it's a good place to look for
> HELP!

Best place to ask:
http://groups.google.com/group/mapinfo-l?hl=en



Posted by relms on September 11, 2008, 6:00 pm


> > Using the SQL Select function in MapInfo Professional ... I'm wanting
> > to display only those rows return from the statement
> > "Count(*),Unique_ID" ... In the Select Columns: box ... When the
> > resulting count is greater than 1 ... In the return browser.
> > Would anyone like to assist in what is required ... I was guessing a
> > "1"] ... But I getting the syntax error message "Variable or Field
> > Count not defined".
> You have to do it in 2 steps:
> select field,count(*) from table group by field into tmp
> select * from tmp where col2>1
> > I'm just starting to learn ... But still need to learn a lot more ...
> > And self teaching from Google is never the easiest method at the best
> > of times ... But I'd like to feel that it's a good place to look for
> > HELP!
> Best place to ask:http://groups.google.com/group/mapinfo-l?hl=3Den

G'Day Uffe,

Thanks for your quick response ... I've tried your suggestion ... LOL
& Behold ... It works ... Again ... Ta.

Just wish it could of been done in one execution.

HooRoo

Posted by Me on September 11, 2008, 6:37 pm


> Thanks for your quick response ... I've tried your suggestion ... LOL
> & Behold ... It works ... Again ... Ta.
>
> Just wish it could of been done in one execution.
>
> HooRoo

Hi,

look as "SQL subquery" in google... you might find interesting info
(though I haven't used MapInfo in a while, though it might be impossible
to apply)

Related Posts
  • Subject
  • Posted In
  • Date