Hi everyone,
I have a problem which I think you people can solve.
I am having problems. I have a table which stores surveys submitted. We
have multiple types of surveys, hence a person can have multiple
surveys under his/her name. These surveys have priorities from 0 (min.)
to 3 (max.). My problem is, I want to pick the whole record for a
survey with the maximum priority. For example, I might have 3 survey
records under the name "John Smith" with survey priorities 0,1,2. I
wish to pick the whole survey record which has survey priority 2. And I
wish to do this for each person in the table. I hope I was clear in
explaining the problem. Can anyone help me with this.
Thanks
Nitin