How to sum the records of Varchar2 and Null Values?

Question

In my table I have same dates but with different Invoice_no_pawl varchar2 and Null. How to show the 1200.00 in the first place and of the date?

This is the query:

select invoice_date, invoice_no_pwal, invoice_value, payment_rec
from partywise_accounts_ledger
where name_of_the_customer = 'Naresh Agencies'

Just simply group by the date field... – Shadow Mar 15 '17 at 06:22 — Shadow, Mar 15 '17 at 06:22
Is varchar2 really a MySQL type? – jarlh Mar 15 '17 at 08:07 — jarlh, Mar 15 '17 at 08:07

score 0 · Accepted Answer · edited May 23 '17 at 11:46

0

ORDER BY column1 DESC, column2

This sorts everything by column1 (descending) first, and then by column2 (ascending, which is the default) whenever the column1 fields for two rows are equal.

Best of luck!

Reference: Here

edited May 23 '17 at 11:46

Community

1
1

answered Mar 15 '17 at 07:27

Ajmal Jamil

799
1
8
15

How to sum the records of Varchar2 and Null Values?

1 Answers1