Showing results for 
Search instead for 
Did you mean: 

table db query

Ferdi Castro

table db query

I have a bank table that looks like below
Denom Serial created
$10 333111 10-MAY-06
$10 111888 09-APR-06
$5 555666 01-JAN-89
$20 666877 09-SEP-98

I selected number of denominations created
"select distinct(denom),count(*) from bank which is ok.
Now I wanted to select denom, the number of denom created yesterday, & total denoms created as of yesterday in single output. Can someone help me here . thanks in advance...
Brian Crabtree
Honored Contributor

Re: table db query

Hmmmm. I think I understand what you are asking for, so try something like this.

select denom, count(*) from back where created > trunc(sysdate)-1 and created < trunc(sysdate);

That should get you only yesterday (by that, I mean 12am to 12am). Also, I'm assuming Oracle in this case.

Indira Aramandla
Honored Contributor

Re: table db query

Hi Ferdi,

As Brian mentioned you can use the sysdate to get the the previous / next dayas records.

For eg:- This query will give you records
$5 555666 ---- which are before January 2006.

SQL> SELECT distinct denom, count(*()
FROM bank
WHERE created < '01-JAN-2006'

For yesterday use sysdate -1

To manupulate the datetime use the to_char(created,'DD-MON-YYYY:HH:MI:SS')

Indira A
Never give up, Keep Trying