Here is mysql table

```
version filename     fileid time(epoch)
1   abc      NULL    123456
2   abc      100     234568
3   abc      100     344568
4   abc      100     445678
5   abc      100     554568

```

Required output

```
version  filename     fileid    time(epoch)
5        abc          100       554568

```

Tried

```
SELECT MAX(VESRION), MAX(time), filename, fileid
FROM table filename, fileid

```

Getting this but not want

```
version  filename     fileid    time(epoch)
5        abc          100       554568
5        abc          NULL      123456

```

Anyone help ?

Thanks !!