As a newb, I already know that I will be birited to ask this question, but I The answer can not be found here and the site can help with some help ...
I have a table that lists the data on a day-by-day basis, and for example by type
transaction. Date | Type ------------------------- Update | 11/7/2008 | Cash-out updates. 11/10/2008 | Written check deposit. 11/11/2009 | Cassand check update | 11/18/2008 | Submit Check Deposit 11/19/2009 | CASAD CHECK
What I am trying to do is the first occurrence of each transaction type, and the last event of each transaction type is. Therefore, I am trying to find out a SQL statement which I can write which will return something like this:
Transaction | First date End date ---------------------------------------------- Update | 11/7/2008 | 11/18/2008 | Deposit | 11/11/2009 | 1/19/2009 |
Any ideas? Select transaction, MIN [[date]] as [first date], max
([Date]) From the My_Table group for transaction from AS [last date]