I have a table with the followings columns:
Year, Month, Day, mics info.
I am trying to write a query where I get one one record. The requirements is that the record is lowest year number. In my attempts I get just one year, but with several records. It happens to be the same number of records for that lowest number year.
Can someone advise me what I am missing?
Thanks