<div>
select tillname, to_char(timestamp,'mm-dd-y<wbr />yyy') as Reboot_Day, count(*)<br />
from audit<br />
group by tillname, to_char(timestamp,'mm-dd-y<wbr />yyy')
</div>


select tillname, to_char(timestamp,'mm-dd-yyyy') as Reboot_Day, count(*)
from audit
group by tillname, to_char(timestamp,'mm-dd-yyyy')

<div>
hi,<br />
<br />
on one day the till will reboot more than once but i only want to record the fact it rebooted once<br />
<br />
thanks<br />
H
</div>


hi,

on one day the till will reboot more than once but i only want to record the fact it rebooted once

thanks
H

<div>
Can you show a sample of your required output? The answer that rmandra gave looks OK to me. Do you want to show just the days that have reboots? Then it's just a distinct, something like this:<br />
<br />
select distinct(to_char(timestamp<wbr />,'mm-dd-yy<wbr />yy'))<br />
from audit;
</div>


Can you show a sample of your required output? The answer that rmandra gave looks OK to me. Do you want to show just the days that have reboots? Then it's just a distinct, something like this:

select distinct(to_char(timestamp,'mm-dd-yyyy'))
from audit;

<div>
Try to select till_id &nbsp;, max(reboot time) , and count(), &nbsp;Grouping By till_id.
</div>


Try to select till_id  , max(reboot time) , and count(),  Grouping By till_id.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a table which logs all reboots of a till on our system;<br />
I need a query to see on a particular day how many tills rebooted - problem is that some times a till may reboot 3 times in a day and record three records into my table but i only need to show this as one:<br />
<br />
my table is called audit: columns are:<br />
<br />
id<br />
timestamp<br />
tillname<br />
<br />
thanks<br />
H
</div>
</div>


Hi,

I have a table which logs all reboots of a till on our system;
I need a query to see on a particular day how many tills rebooted - problem is that some times a till may reboot 3 times in a day and record three records into my table but i only need to show this as one:

my table is called audit: columns are:

id
timestamp
tillname

thanks
H

sql query

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.