Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
2 8
Impact
~11k people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Feb
2
asked PostgreSQL, how to query the database to retrieve the percentile elements of a dataset?
Jan
19
awarded  Popular Question
Sep
2
accepted PostgreSQL, how to extract all the possible couples of a primary key in a table?
Sep
2
asked PostgreSQL, how to extract all the possible couples of a primary key in a table?
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