1011 2 3
Can this be what you need?
Best,
Oliver
- Original Message -
From: "Adrian Johnson"
To:
Sent: Thursday, September 23, 2010 4:30 AM
Subject: [SQL] unique fields
hi:
I have a fairly large table.
sample_id | chr
Hi,
On 23 September 2010 07:30, Adrian Johnson wrote:
> I want to find out how many duplications are there for chr, cfrom and cto
Start with it http://www.postgresql.org/docs/9.0/interactive/tutorial-agg.html
p.s.
SELECT chr, cfrom, cto, count(*) FROM your_table GROUP BY 1, 2, 3;
>
> a. c2,
hi:
I have a fairly large table.
sample_id | chr | cfrom | cto |
---
1c219 20
2c219 20
3c219 20
1c510 11
3c510 11
(25,000 row
