147 reputation
115
bio website
location Delhi
age 24
visits member for 1 year, 9 months
seen Mar 21 at 3:28

(your about me is currently blank)

click here to edit


Mar
5
asked Why does Oracle store time in DATE column?
Feb
7
awarded  Famous Question
Dec
6
asked See list of queries executed by a user in Oracle
Dec
3
awarded  Editor
Dec
3
revised How to get SQL for DDL commands in Sql developer?
added 237 characters in body
Dec
3
asked How to get SQL for DDL commands in Sql developer?
Nov
29
comment How to make sqlplus output appear in one line?
I'd also like the columns to auto-expand instead of me having to set the column size for each individually.
Nov
29
asked How to make sqlplus output appear in one line?
Aug
21
asked Define a column as MD5 sum of other columns in MySql
Jul
5
awarded  Notable Question
May
16
awarded  Popular Question
Apr
23
accepted How to properly format sqlite shell output?
Apr
23
asked How to properly format sqlite shell output?
Jan
29
accepted Mysql not closing connections
Jan
29
asked Mysql not closing connections
Dec
27
comment How to number SQL results sequentially?
Thanks that works.
Dec
27
accepted How to number SQL results sequentially?
Dec
27
comment How to number SQL results sequentially?
@ypercube Yup that would do.
Dec
27
asked How to number SQL results sequentially?
Dec
15
comment How to aggregate datapoints in a table?
@dezso My DB is H2 but you can post a solution in Mysql or other RDBMS. I'll understand the query and try to port it. As of yet I have no idea how to approach the problem. The ordering is done by datetime.