If the timestamps are unique you could try including a subquery which
gets the next lowest date
eg. (not sure if this is valid SQL syntax, I'm not meant to be on the PC
:) Select data, datetimefield, (select top 1 datetimefield from table1
where datetimefield < A.datetimefield order by datetim
No, I'm afraid not. What's your final output? If its a report, you may
want to consider a reporting tool ( Jasper/BIRT/etc ) to satisfy this
requirement.
On Sat, Jan 11, 2014 at 8:49 AM, Cecil Westerhof wrote:
> 2014/1/11 Atul Chowdhury
>
>> You're probably after something like the BREAK dire
On Fri, Jan 10, 2014 at 5:21 PM, Dave Atkins wrote:
> I recently shutdown this H2 database and after restarting the service, I can
> no longer connect via TCP. I've been troubleshooting from command line; the
> web interface just times out. Here's what I see:
The most likely answer is simply tha
2014/1/11 Atul Chowdhury
> You're probably after something like the BREAK directive found in SQL*Plus.
>
> See: http://docs.oracle.com/cd/A84870_01/doc/sqlplus.816/a75664/ch42.htm
>
> SQL> BREAK ON DEPTNO
> SQL> SELECT DEPTNO, ENAME, SAL
> 2 FROM EMP
> 3 WHERE SAL < 2500
> 4 ORDER BY DEP
You're probably after something like the BREAK directive found in SQL*Plus.
See: http://docs.oracle.com/cd/A84870_01/doc/sqlplus.816/a75664/ch42.htm
SQL> BREAK ON DEPTNO
SQL> SELECT DEPTNO, ENAME, SAL
2 FROM EMP
3 WHERE SAL < 2500
4 ORDER BY DEPTNO;
SQL*Plus displays the following output
I run H2 as a service. A certain database I fill with a bash-script called
from a cron job. The strange thing is that when I insert records when the
database has not been opened the insert takes about .5 seconds. When I open
the database in my browser it takes about .15 seconds. (So more as three
t
2014/1/10 Noel Grandin
>
>
> On 2014-01-09 23:43, Cecil Westerhof wrote:
>
>> This works fine, but I would prefer to only have Date shown when it is
>> different as the previous Date. Is this possible?
>>
>
> Depends on what you mean by "previous date"?
> You didn't show the table definition, so