I have a table named READING this table contains POINT_DETAIL_ID , VALUE and TAKEN fields. This table is used to store measurements taken on a point. Our consultants have asked for a report which lists the POINT_DETIAL_ID and the last two VALUES asscoitated with the Point Detail.
Does anybody have an idea if it is possible using SQL and if so how.
Many many thanks.