asked on 5/25/2012

sql query

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

Oracle Database SQL

Last Comment

Hamed Nasr

5/27/2012

rmandra

5/25/2012

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

hraja77

5/25/2012

ASKER

hi,

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

thanks
H

ASKER CERTIFIED SOLUTION

Ess Kay

5/25/2012

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Gerwin Jansen

5/25/2012

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;

Hamed Nasr

5/27/2012

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