Here i have the invoice details table.
I need the all values without duplicate of `[invoiceno]`.
I am try 

```
select distinct invoiceno,name,addr1,addr2,id from invoice_table;

```

Result:

```
invoiceno    name             addr1       addr2             id
2016718001  Severus Sanpe   7,Hogwards, Sevilee,USA 7451    5
2016718002  Severus Sanpe   7,Hogwards, Sevilee,USA 7451    8
2016718002  Severus Sanpe   7,Hogwards, Sevilee,USA 7451    9

```

I want the result:

```
 invoiceno   name             addr1       addr2             id
2016718001  Severus Sanpe   7,Hogwards, Sevilee,USA 7451    5
2016718002  Severus Sanpe   7,Hogwards, Sevilee,USA 7451    8

```

It's working fine without `id` in `SELECT`. But i need that also. 
How to do this?