General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Index, sort order question
I have a table of collateral items. The collateral items belong to an loan. The collateral table has the field obligation, seq, desc, start_dt, comp_dt. One obligation can have many collateral records, so the seq field is a numeric field that starts at 1 for each new obligation collateral item.
I want to be sort the table records so that the "to do" items are shown first. Meaning that the records with the earliest start_dt that has an empty(compt_dt) should show first. But .... the obligation records need to stay together in a group by obligation, seq order.
If I could accomplish this in an index that would be ideal.
Any help would be appreciated.
Brenda
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only