SELECT single record using an incomplete key
I was always told that, when selecting a single record, I should use UP TO 1 ROWS
whenever the key was not fully provided. My elementary school teacher told me that I should always aks why: why? Nobody ever told me why.