what are the features of DISTINCT other than eliminating duplicate values,does it allows NULL values more than once?
Answer Question | March 31, 2012 2:09 PM
Hey guys, I have been working on the query running against MS access database. The table has multiple columns and two of them (which are vital to this query) are Date and ItemN ( suggesting Item number). There are multiples which show multiple entries for single itemN, for example. item 1 has three date entries [...]
Answer Question | April 18, 2013 6:44 PM
Aggregate function, Distinct, MAX, Microsoft Access, Query, SQL, Subquery