Hi all,
I have to follow up on my own mail:
Joerg Bruehe wrote:
[[...]]
For tabular form, try along these lines (untested):
SELECT MIN(id), email, id
FROM addressbook
WHERE id MIN(id)
GROUP BY email
HAVING COUNT(*) 1
I cannot explain what made me write that, other than lack
Hello:
I have the following table
select * from addressbook
+++
| id | email |
+++
| 1 | [EMAIL PROTECTED] |
| 2 | [EMAIL PROTECTED] |
| 3 | [EMAIL PROTECTED] |
+++
3 rows in set (0.00 sec)
Now i wanted
Hi Yashesh, all !
Yashesh Bhatia wrote:
Hello:
I have the following table
select * from addressbook
+++
| id | email |
+++
| 1 | [EMAIL PROTECTED] |
| 2 | [EMAIL PROTECTED] |
| 3 | [EMAIL PROTECTED] |
Taking it step by step, this query will give you all the lowest ids,
for those records with duplicates.
SELECT min(id), email, count(*) AS cnt
FROM addressbook
GROUP BY email
HAVING cnt1
Now think of that query as an already existing table, which you can
do, you just need to name the query
