I've got the following Table:
dataid Name Vernum valstr
5088726 cvp.docx 2 Internal
5088726 cvp.docx 3 Personal
5088726 cvp.docx 1 Strictly Confidential
I want as result one row. I need the value of column valstr where the value of the column is the highest.
I my example the result must be personal.
How Can I do it?
I tried to work with group by but it's not correct...i hope you will have a hint for me....