123 reputation
6
bio website davidechicco.it
location University of California Irvine
age
visits member for 2 years, 7 months
seen Aug 5 '13 at 11:12

Computer Engineering Visiting Research Scholar

University of California Irvine

Orange County, California, USA

http://www.davidechicco.it

davide.chicco(AT)gmail.com


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