query help

Posted on 16th Feb 2014 07:03 pm by admin

Hi experts.

i have a table rep2 like this
PROD_COD ACCT_NO DUE_DAYS BALANCE LIMIT
1 1 101 15 100 200
2 1 102 17 150 200
3 1 103 32 500 1000
4 2 201 30 250 300
5 2 202 60 800 1000
6 3 301 62 900 1500
7 3 302 90 400 800
8 3 303 98 600 1200

and i am running below query on the table

select '720+', prod_cod, count(acct_no), sum(balance), sum(limit)
from rep2
where due_days > 720
group by prod_cod;

but o/p is "0 rows selected".

how to show the o/p like this
720+ , null,0,0,0 .
in other words i want to show the record even if the condition doesn't satisfy.

thanks

Your Answer:

Login to answer

Other forums

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

Mail Script Problems
I have created a PHP mail script. I am having a problem though. In $body i am trying to put two va

imap: how to save a copy of sent emails to sent elements
Hello my friends,

I am writing an online emailing application with inbox outbox/sent elements

Encrypt php code?
Is it possible to encrypt php code in files,
so that it displays a load of unreadable characters

Display last record first.
I need some help how put the last record first and first record last.

Thanks

Code: &am

Form submissing with PHP and JQuery/Ajax
I have searched everywhere, but cannot find a solution for this... I have worked all day trying to g

void* and sizeof()
Hi,

Using void* and sizeof is it possible to get the value of the object ?

I understan

How to ask a regex question?
Hi, I thought I'd share some of my insight after seeing too many bad questions that either get ignor

Is STL important?
I'm just starting programming and I've made it until the Standart Template Library. But the chapter

Access database inside of a validation class
Hello,

For quite some time, I have been using functions to validate form input and access the