123 reputation
7
bio website davidechicco.it
location Toronto, Ontario, Canada
age
visits member for 2 years, 9 months
seen Aug 5 '13 at 11:12

Bioinformatics and machine learning post-doctoral fellow

Princess Margaret Cancer Centre, University of Toronto

Toronto, Ontario, Canada

http://www.davidechicco.it

davide.chicco(AT)gmail.com


Sep
24
awarded  Autobiographer
Jul
30
awarded  Popular Question
Aug
5
comment How to create an Sql table from SELECT with a multiple row DISTINCT constraint?
But I'm not interested in the order, later I'll do just a COUNT(*)... should I use the ORDER BY clause anyway?
Aug
5
awarded  Scholar
Aug
5
comment How to create an Sql table from SELECT with a multiple row DISTINCT constraint?
It worked, thanks! I did not need the IN ORDER clause.
Aug
5
accepted How to create an Sql table from SELECT with a multiple row DISTINCT constraint?
Aug
5
asked How to create an Sql table from SELECT with a multiple row DISTINCT constraint?
Jul
3
awarded  Popular Question
Mar
22
awarded  Supporter
Mar
22
comment Filtering data that could have more than one category
@dezso Is the first "EXISTS ( SELECT .." query mandatory? I tried this: SELECT document, term FROM Annotation ann WHERE category = 1 AND NOT EXISTS ( SELECT 1 FROM Annotation a WHERE a.document = ann.document AND a.term = ann.term AND category <> 1 ). Is this correct the same?
Sep
24
awarded  Tumbleweed
Sep
17
asked Exporting data from Microsoft Access table file subsets to plain text
Feb
15
awarded  Student
Jan
12
asked Postgres PgAdmin III Query Builder crash