Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm hoping this will be a relatively simple query. I have a large amount of data and I only want to load the most up to date information. Table 1 belows shows an example of what I currently have, and basically I only want the latest DateChange data to come across, which is shown in Table 2. It seems to be an easy concept however I can't think of what to do in the script.
Thanks
Table 1
AccountNo | DateChange | Tariff |
---|---|---|
AB123456 | 05/02/06 | HE |
AB123456 | 04/08/10 | E7 |
CD123456 | 02/01/03 | HE |
CD123456 | 05/04/07 | E7 |
CD123456 | 08/09/09 | HE |
EF123456 | 02/03/07 | HE |
GH123456 | 02/05/08 | E7 |
Table 2
AccountNo | DateChange | Tariff |
---|---|---|
AB123456 | 04/08/10 | E7 |
CD123456 | 08/09/09 | HE |
EF123456 | 02/03/07 | HE |
GH123456 | 02/05/08 | E7 |
Check out this attached application.
- Sridhar
That's great sridhar24784, many thanks for this.