| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Gobi | Date: | November 4 2005 8:05am |
| Subject: | Help with an SQL query | ||
| View as plain text | |||
Not sure if this is the right place to ask. I have a table, Weight, with the following test data: idx VBS_ID Date Weight 1 111111 10/3/2005 11.5 2 111111 9/5/2004 10 3 111111 10/7/2005 11.51 4 111111 10/8/2005 11.52 5 111112 10/8/2005 10.5 6 111112 10/1/2005 10.3 7 111112 9/28/2005 10 What I would like to do is to get the most recent weight for each unique VBS_ID. So, in this case, I want a result of: 111111, 10/8/2005, 11.52 111112, 10/8/2005, 10.5 Can anyone tell me how to do this? Thanks.
| Thread | ||
|---|---|---|
| • Help with an SQL query | Gobi | 4 Nov |
| • Re: Help with an SQL query | Arno Coetzee | 4 Nov |
| • Re: Help with an SQL query | Gobi | 4 Nov |
| • Re: Help with an SQL query | Gobi | 4 Nov |
| • Re: Help with an SQL query | Johan Höök | 4 Nov |
| • Re: Help with an SQL query | Gobi | 4 Nov |
| • Re: Help with an SQL query | Gobi | 4 Nov |
| • Re: Help with an SQL query | Rhino | 5 Nov |
| • Re: Help with an SQL query | Gobi | 6 Nov |
| • Re: Help with an SQL query | Johan Höök | 4 Nov |
| • Re: Help with an SQL query | Gobi | 4 Nov |
| • How to select on passwords? | Gobi | 4 Nov |
| • Re: How to select on passwords? | Gobi | 4 Nov |
| • Re: Help with an SQL query | Gobi | 5 Nov |
