Andomar

Netherlands

Age: 41

I'm a software developer at a telco supporting line-of-business applications. We use a variety of technologies from ASP.NET to Perl. I've come to appreciate SQL more over time, and I now spend most of my time in the database.

If you'd like to learn SQL properly, consider the free SQL course from Stanford. For more free online courses awesomeness, check out the list of courses on Coursera and EdX.

4h
awarded Caucus
10h
awarded left-join
14h
awarded Enlightened
14h
awarded Nice Answer
2d
comment How to fix SQL query with Left Join and subquery?
Now the query has start and end time mixed. Start time should be smaller than the current timestamp, not larger.
2d
comment How to fix SQL query with Left Join and subquery?
@JoachimIsaksson: good point, or maybe UNIX_TIMESTAMP() between stn.stocksStartDate and stn.StocksEndDate
2d
answered How to fix SQL query with Left Join and subquery?
Jul
23
awarded Populist
Jul
22
answered Select previous row for each entry in Table/List
Jul
22
revised SQL: the most effective way to get row number of one element
added 299 characters in body
Jul
22
answered SQL: the most effective way to get row number of one element
Jul
22
revised SQL Increment column value in select statement
edited tags
Jul
22
comment SQL Increment column value in select statement
Duh, you're right :) I'll remove the comments in a sec +1
Jul
22
comment SQL Increment column value in select statement
This would sort 50 in the 51-100 bucket (easy fix: subtract 1 from revenue)
Jul
22
answered SQL Increment column value in select statement
Jul
21
comment Postgres Streaming Replication Disk Usage Discrepancy
Postgres' data directory contains many things, including logging, that will be different between master and standby. Comparing the number of blocks they use makes no sense.
Jul
20
revised How to insert one field of a table to another table in laravel 5?
added 18 characters in body
Jul
20
comment IF ELSE condition asp net with SQL Server
@RJ10: That means the second argument to new SqlCommand(query, connection) (the connection) is empty. It should contain an open connection.
Jul
20
answered Nested cursor, While Loop SQL
Jul
20
revised how to write a query that produces the following output from the below tables
added 12 characters in body; edited title
1 2 3 4 5