but I fail to get it done.
Hello,
I got the following problem, that I cannot get worked out.
I have a table that has 3 columns A, B and C.
C is a boolean Column, that indicates if the record has been logically
deleted, It shall not be removed from the database.
The table shall be ordered according to A. (Order by A)
But if C ist true and to the value B1 in this Record, there exists
another Record with B2 and B2 = B1, then B1 should be ordered in the row
above B2.
B
A
C 1=true, 0 = false
307
{null}
1
307
{null}
1
307
{null}
1
307
1.7
0
301
1,5
1
301
2
0
304
3
0
305
3
1
305
3
0
Thank you very much for any help.
