Re: How to write this query without using subquery in the FROM clause?
- From: "Roy Hann" <specially@xxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 25 Jun 2007 07:49:34 +0100
<simonl@xxxxxxxxxxxxxx> wrote in message
news:1182738601.128789.15250@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I reported a similiar bug back in 2004 on 2.5. It was decreed that a
patch was unnecessary at the time. But the bug should still have been
fixed, unless this is a different problem.
An alternate way of writing it would be:
select count(al_ccode)
from airline
group by al_ccode
having count(*) > 1
Actually that just returns the set of duplicate counts for airlines with
duplicates, not the *size* of the set, which is what the OP wants.
Roy
.
- References:
- How to write this query without using subquery in the FROM clause?
- From: tianfeichen
- Re: How to write this query without using subquery in the FROM clause?
- From: Roy Hann
- Re: How to write this query without using subquery in the FROM clause?
- From: tianfeichen
- Re: How to write this query without using subquery in the FROM clause?
- From: Roy Hann
- Re: How to write this query without using subquery in the FROM clause?
- From: simonl
- How to write this query without using subquery in the FROM clause?
- Prev by Date: Re: Ingres JDBC driver hangs on getting a connection
- Next by Date: Re: How to write this query without using subquery in the FROM clause?
- Previous by thread: Re: How to write this query without using subquery in the FROM clause?
- Next by thread: Re: How to write this query without using subquery in the FROM clause?
- Index(es):
Relevant Pages
|
|
