When I want to select max value from code (code below). It shows me 2 max row result. But I want to get one max value.
Code below:

```
select 
distinct(c.msisdn), 
max(adj_date),
6144 - (round(t.volume /1024/1024,2))as остаток_мб 
from 
subscriber_discount_threads t, 
client_balance c, 
subs_packs p 
where 
t.dctr_dctr_id = 1283 
and p.pack_pack_id in (877,874) 
and c.msisdn = '550350057' 
and t.adj_date >= '30.10.2015' 
and sysdate between p.start_date and p.end_date 
and sysdate between t.start_thread and t.end_thread  
and c.subs_subs_id = t.subs_subs_id 
and p.subs_subs_id = c.subs_subs_id 
group by c.msisdn, t.volume

```

result below (2 row, but i want that shows me only max date)

```
25.11.2015 13:08:06
03.11.2015 11:42:06

```

What could be the problem?