Group By query

G

Guest

I have a table as shown below

TABLE NAME:BAL

Account Date Balances
OTC 01-Jan-07 1000
OTC 02-Jan-07 6000
OTC 03-Jan-07 3000
OTC 04-Jan-07 4000
OTC 05-Jan-07 5000
ICT 01-Feb-07 2500
ICT 02-Feb-07 3000

I want to extract the row which has the latest date with corresponding
balance from table BAL

Result expected is as shown below

Account Date Balances
OTC 05-Jan-07 5000
ICT 02-Feb-07 3000
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating occupational sick pay entitlement 0
Monthly transactions in query 3
Need to transform the dates to months 4
Combine 2 Charts 2007 Excel 1
SQL for Multiple Parameters 2
How to select the date? 4
How to lookup given value from a range (with upper with lower limit) 2
How to avoid Duplicate values .. but want the first value to added in group totals 0

Top