[SQL] unique fields

2010-09-22 Thread Adrian Johnson
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

Re: [SQL] Help with queries.

2010-09-21 Thread Adrian Johnson
Hello Oliver. thanks for your reply. Here are my answers. Sorry I shot e-mail in morning and I was not clear about it. I am afraid, I am not jamming you with all information. Thank you very much for your help. == your questions ==

[SQL] Help with queries.

2010-09-21 Thread Adrian Johnson
Dear group, I just started learning postgres and I have to analyze my data. So please bear with me, for all the simple questions that I am asking. Apologies. I have a table: snps table id | sample_id | chromosome | from | to | -