2,896 reputation
21021
bio website datajini.com
location Frösön, Sweden
age 41
visits member for 2 years, 4 months
seen 7 hours ago

I'm an Oracle Database Specialist at DataJini, an Oracle consultancy that specialises in building solutions using MDD techniques.


Dec
11
reviewed Edit Getting wrong results from fulltext search in PostgreSQL
Dec
11
revised Getting wrong results from fulltext search in PostgreSQL
Codified, fixed typos
Dec
11
reviewed Reviewed Does it make sense to order condition in where query?
Dec
11
reviewed No Action Needed what should be the good normalization for the following scenario?
Dec
11
reviewed No Action Needed MySQL Workbench is not finding MySQL service?
Dec
11
reviewed Reviewed RAC vs Application Server Grid
Dec
10
reviewed Looks OK Cannot enter psql command “FATAL: the database system is starting up”
Dec
10
comment Counting repeated occurences for a group of fields
No, it's a tag. I've tagged this question, but maybe other questions and answers will help you. You'll almost certainly need to use window functions to identify the start and/or end of the sequences you're interested in (partitioning by person and ordering by time). I started to write a query but I would need sample data: can you edit your question to include this as a script, or a link to a SQL Fiddle containing said data?
Dec
10
revised Counting repeated occurences for a group of fields
edited tags
Dec
10
reviewed No Action Needed mysql replication not working
Dec
10
reviewed No Action Needed Open tran for Select query
Dec
10
comment Counting repeated occurences for a group of fields
@Ypercube Probably.
Dec
10
comment Counting repeated occurences for a group of fields
Or should Dave be 6?
Dec
10
reviewed No Action Needed Counting repeated occurences for a group of fields
Dec
10
reviewed Reviewed ORA-01779: cannot modify a column which maps to a non key-preserved table
Dec
10
comment ORA-01779: cannot modify a column which maps to a non key-preserved table
possible duplicate of Oracle: Non key-preserved table should be
Dec
10
reviewed No Action Needed Migrate SQL Server database to multiple files (shrinkfile emptyfile vs log shipping)
Dec
10
reviewed Reviewed How to empty a column in mysql
Dec
10
comment How to empty a column in mysql
"empty"? Please show us the SQL you (would) use(d).
Dec
9
reviewed No Action Needed Update all data in a table without affecting ID(PK)