Sugheer,

> I have a table data like this

...

> Either debit or credit will have only one entry.

Although you could write a SELECT statement, to be honest the better
solution would be to change you table schema to add a new column to
'mark' the details rows you need to report on. Is that an option?

A SELECT statement would perform VERY VERY POORLY.


Sean