Distinct Questions

1

DISTINCT in sql
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
Distinct
asked by:
5 pts.

SQL query – Unique item with latest date of entry
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
asked by:
15 pts.

1