Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

Re^2: (OT) Exclusion selection on DBI

by fernandes (Monk)
on Jan 25, 2008 at 12:37 UTC ( #664276=note: print w/replies, xml ) Need Help??

in reply to Re: (OT) Exclusion selection on DBI
in thread (OT) Exclusion selection on DBI

I'm going to update the node. There is a column I've not talked about.
Anyway, the problem about GROUP approach is that it selects only the last row of each group. It produces:

Orange, green
Mellon, white

But I really need to see the complete list of rows where is repeated:

Orange, yellow
Orange, green
Mellon, red
Mellon, white


Replies are listed 'Best First'.
Re^3: (OT) Exclusion selection on DBI
by mpeppler (Vicar) on Jan 25, 2008 at 13:21 UTC
    Actually moritz's solution gives you the data you want:
    [59] 5010.my_db2.(sa).1> select * from fruit; t c -------------------- -------------------- orange yellow orange red banana yellow mellon yellow mellon red raisin green (6 rows affected) [61] 5010.my_db2.(sa).1> select t, c, count(*) from fr +uit group by t having count(*) > 1 order by t; t c -------------------- -------------------- ----------- mellon red 2 mellon yellow 2 orange red 2 orange yellow 2 (4 rows affected)
    This is using Sybase ASE 15.


Re^3: (OT) Exclusion selection on DBI
by roboticus (Chancellor) on Jan 25, 2008 at 12:57 UTC

    You really ought to mark your updates better so people reading the thread aren't confused. In this case, you could have left the original message alone and just added the new information.

    Anyway, on to your question: Just add ',color' to the 'group by' clause in moritz's answer.


Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://664276]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (5)
As of 2021-10-26 09:45 GMT
Find Nodes?
    Voting Booth?
    My first memorable Perl project was:

    Results (90 votes). Check out past polls.