I have following table

```
 ID    Date  quantity storename  
 id1 01-01  1       A1  
 id2 01-03  3       A2  
 id1 01-03  40      A2  

```

I want to see

```
 ID    Date  quantity storename  
 id1 01-03  40       A2  
 id2 01-03  3        A2  

```

So basically I would like to groupby ID and find the max(newest) date. Then get the entire row data from that max(newest) date.

I tried the following code and it's not working out.

```
SELECT ID, max(Date), quantity, storename FROM table
GROUPBY ID

```

Also, is it possible to get all the columns(Like using \*) instead of specifying one by one?