Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: Sort label

by Roy Johnson (Monsignor)
on Jul 18, 2005 at 14:00 UTC ( [id://475765]=note: print w/replies, xml ) Need Help??


in reply to Sort label

I think you just want to modify your query to do the elimination: 
SELECT id, num
FROM   index i1
WHERE  id LIKE ?
  AND NOT EXISTS (
    SELECT 1 FROM index
    WHERE  id = 'G'||Substr(i1.id, 2)
  )

[download]
Index is a poor choice for a table name, by the way.
Caution: Contents may have been coded under pressure.

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://475765]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others examining the Monastery: (9)
As of 2024-04-23 10:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found