Quote:
Originally Posted by blindman
What constitutes a distinct record? You have a surrogate ID, so there should not be any duplicates. What is the natural key for your table?
|
Natural key is id but i want to work out average on the ticket_id of which there can be duplicates.