Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
2 7
Impact
~6k people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
Mar
24
awarded  Notable Question
Mar
6
awarded  Notable Question
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