This is a test I did on one of my tables where I put duplicated entries :
select *
from acct_other_2003sep
except select sep.*
from (
select min(oid) as min_oid,
"Acct-Status-Type",
"User-Name",
"Realm",
"Acct-Session-Time",
"Acct-Input-Octets",
"Acct-Output-Octets",
"Called-Station
The world rejoiced as [EMAIL PROTECTED] (Christoph Haller) wrote:
>> 1. How to select duplicate records only from a single table using a
> select
>> query.
>>
> e.g.
> select sid,count(sid) from location group by sid having count(sid)>1;
>
> Do you get the idea?
> Your request is pretty unspecific,
> 1. How to select duplicate records only from a single table using a
select
> query.
>
e.g.
select sid,count(sid) from location group by sid having count(sid)>1;
Do you get the idea?
Your request is pretty unspecific, so if this is not what you're asking
for,
try again.
Regards, Christoph
---
Hi
I would like to know the
following
1. How to select duplicate records
only from a single table using a select query.
Thanks in advance
Regards
naveen
- Original Message -
From:
yogesh selukar
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: Saturday, September 20,
