Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
2 9
Newest
 Informed
Impact
~12k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
Mar
9
accepted Postgres PgAdmin III Query Builder crash
Feb
24
asked Lua and Torch, how to implement a connection pooling in LuaSql?
Feb
24
awarded  Informed
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