Re: Selecting the latest entries

2003-12-27 Thread Roger Baklund
* Ville Mattila > I have a table containing weather reports of different types and cities. > The structure is following: > - type > - city > - time > - report > > Which kind of query should I use to select the latest reports of > specified cities. I mean, if I had three different types of repor

Selecting the latest entries

2003-12-25 Thread Ville Mattila
Hi there, This subject might be discussed before, but I couldn't find any mail from the archives. I have a table containing weather reports of different types and cities. The structure is following: - type - city - time - report Which kind of query should I use to select the latest reports of